I'm trying to use the SHOW TABLES command in order to show my tables that I've created in mysql database. HOwever, I have questions.
My code:
$sql="SHOW TABLES FROM food";
$result=mysql_query($sql);
if (!$result) {
echo "DB Error, could not list tables\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_row($result)) {
echo "Table: {$row[0]}\n";
}
mysql_free_result($result);
?>
The output does show the tables. BUT it shows the word TABLE in front of my table names. I do not want the word table to show up. In fact, I would actually if posible like my tables to be links that a user can click on to bring up information (or in my case more php code
of that link. I just thought that displaying the tables is better than manually creating an array and changing each time someting gets done...less tedious anyways.
Any suggestions on this? Thanks
Threaded Mode
