Schema for table: $table\n";
echo "A total of $numFields fields\n";
echo "";
echo "";
echo " Name | Length | Type | Flags | \n";
echo "
";
while ($i < $numFields) {
echo "\n";
$fName = mysql_field_name($fieldsHandle, $i);
echo "$fName | \n";
$fLen = mysql_field_len($fieldsHandle, $i);
echo "$fLen | \n";
$fType = mysql_field_type($fieldsHandle, $i);
echo "$fType | \n";
$fFlags = mysql_field_flags($fieldsHandle, $i);
echo " $fFlags | \n";
echo "
\n";
$i++;
}
echo "
\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 "$fName | \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 "$fieldValue | \n";
$j++;
}
echo "
\n";
$i++;
}
echo "
\n";
}
mysql_close($conn);
?>