Schema for table: $table\n"; echo "A total of $numFields fields\n"; echo ""; echo ""; echo " \n"; echo ""; while ($i < $numFields) { echo "\n"; $fName = mysql_field_name($fieldsHandle, $i); echo "\n"; $fLen = mysql_field_len($fieldsHandle, $i); echo "\n"; $fType = mysql_field_type($fieldsHandle, $i); echo "\n"; $fFlags = mysql_field_flags($fieldsHandle, $i); echo "\n"; echo "\n"; $i++; } echo "
NameLengthTypeFlags
$fName$fLen$fType  $fFlags
\n"; } if (($viewOption == "both") || ($viewOption == "records")) { mysql_select_db ($db, $conn); /* submit the query */ SetType ($query, "string"); $query = "SELECT * from " . $table; $resultHandle = mysql_query( $query, $conn ) or die ("Could not get DB"); /* table headers */ echo "\n"; echo "\n"; echo "

Records in table: $table

\n"; $i = 0; while ($i < $numFields) { $fName = mysql_field_name($fieldsHandle, $i); echo "\n"; $i++; } echo "\n"; /* table rows */ $numRows = mysql_num_rows ($resultHandle); $i = 0; while ($i < $numRows) { echo "\n"; $j = 0; while ($j < $numFields) { $fName = mysql_field_name($fieldsHandle, $j); $fieldValue = mysql_result ($resultHandle, $i, $fName); echo "\n"; $j++; } echo "\n"; $i++; } echo "
$fName
$fieldValue
\n"; } mysql_close($conn); ?>