/* if delete & edit buttons should be displayed then check for a primary key */
$keys=0;
if ($show_buttons){
$rs=@mysql($dbname,"show fields from $tablename");
// SetErrorReporting(0);
$nf=mysql_numrows($rs);
// SetErrorReporting();
while($j<$nf):
$tmp = mysql_result($rs,$j,"Key");
$fn[$j] = mysql_result($rs,$j,"Field");
if ($tmp=="PRI"){
$key[$keys] = $fn[$j];
$keys++;
}
$j++;
endwhile;
}
/* if no primary key is defined then disable edit & delete buttons */
if ($keys==0){
$show_buttons = "";
}
/* do the Query */
$rs=@mysql($dbname,"$qr");
$err=$phperrmsg;
// SetErrorReporting(0);
$nf=mysql_numfields($rs);
// SetErrorReporting(1);
$tw=0;
$j=0;
while($j<$nf):
$fn[$j] = mysql_FieldName($rs,$j);
$ft[$j] = mysql_FieldType($rs,$j);
$fl[$j] = mysql_FieldType($rs,$j);
$j++;
endwhile;
$j=0;
if (!$limit):
// SetErrorReporting(0);
$nrs=mysql_numrows($rs);
// SetErrorReporting(1);
$show=0;
endif;
$maxnow=$maxrows;
if ($show+$maxnow>$nrs):
$maxnow=$nrs-$show;
endif;
echo "database: $dbname
table: $tablename
";
echo "$query";
echo "
$nrs records
$nf fields
"; echo "
| $table_font_tag $fn[$j] | "; $j++; endwhile; if ($show_buttons){ echo "\n\t"; } echo " |