Data Table Utility";
echo "
";
echo "Race Table Structure
\n";
$good_user = @mysql_connect(
"samba2.ipm.virginia.edu", "selectuser", "")
or $good_user=0;
mysql_select_db( "test");
$selectstring = " show columns from race";
$query_handle = mysql_query( $selectstring);
$num_rows = mysql_num_rows ($query_handle);
echo "| Field Name | " .
"Field Type |
";
for( $i = 0; $i < $num_rows; $i++)
{
echo "";
$row = mysql_fetch_array ($query_handle);
$sizerow = sizeof( $row) / 2;
echo "";
$k = $i + 1;
for ( $j = 0; $j < 2; $j++)
{
echo "| $k $row[$j] | \n";
}
echo "
";
}
echo "
";
// echo "\n $sizerow";
// print_r( $row);
echo "";