database: $dbname
table: $tablename
$nrs fields

"; echo "\n"; $j=0; echo ""; echo "
$table_font_tag Field $table_font_tag Type $table_font_tag Null $table_font_tag Key $table_font_tag Default $table_font_tag Extra $table_font_tag Alter Table"; while($j<$nrs): echo "
\n"; echo "\n"; echo "\n"; $fnm = mysql_result($rs,$j,"Field"); $fty = mysql_result($rs,$j,"Type"); $fnu = mysql_result($rs,$j,"Null"); $fke = mysql_result($rs,$j,"Key"); $fde = mysql_result($rs,$j,"Default"); $fex = mysql_result($rs,$j,"Extra"); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n\t
$table_font_tag $fnm $table_font_tag $fty $table_font_tag $fnu $table_font_tag $fke $table_font_tag $fde $table_font_tag $fex"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; $j++; endwhile; echo "
"; echo "

\n\
"; $rs=mysql($dbname,"show keys from $tablename"); $nrs=mysql_numrows($rs); $nf=mysql_numfields($rs); echo "
$nrs keys present

"; echo "\n"; $i=0; while($i<$nf): echo ""; $i=0; while($i<$nf): $f[$i] = mysql_result($rs,$j,mysql_fieldName($rs,$i)); echo "\n"; echo ""; echo "
$table_font_tag"; echo mysql_fieldName($rs,$i); $i++; endwhile; echo ""; $j=0; while($j<$nrs): echo "
\n"; echo "\n"; echo "\n"; echo "\n\t
$table_font_tag $f[$i]\n"; $i++; endwhile; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo ""; $j++; endwhile; echo "
"; mysql_close(); echo "

\n"; echo "\n\
"; echo "\n"; echo "\n"; echo "\n"; echo "\n
"; echo "
\n"; echo "
go on "; ?>