\n";
print "| Table Name | Number of Rows |
|---|
\n";
for($cnt = 0; $cnt < $numTables; $cnt++){
$table = mysql_tablename($result, $cnt);
$queryString = "SELECT COUNT(*) as rows FROM $table";
if($tableResult = mysql_query($queryString, $db)){
$numRows = mysql_result($tableResult, 0, "rows");
print "| $table | $numRows |
\n";
} else {
print "ERROR: Could not find number of rows in \"$table\"
\n";
}
}
} else {
print "There was an error with listing tables: ".mysql_error();
}
?>