[mejnoona]

I have not had luck in finding what I want to accomplish so I don't know if this is possible. Is there a way to display in a table on an html page the names of the tables in a mysql database? And then when the user clicks on the table name, they will be taken to another page that is more specific to that table and more specific queries can be done regarding that table?
But at the moment all I want to do is create a script that displays the names of the tables only.
Thanks

[mab]

http://dev.mysql.com/doc/refman/5.0/en/show-tables.html

[mejnoona]

Thats the command I was thinking of Thanks
I put in this code though but once again, no output. Remembering the last time I had no output, I tried this with mysql_fetch_arrow and mysql_fetch array but still no output comes on the site. any ideas?

<?php

$query="SHOW TABLE STATUS LIKE 'tablename'";
$result=mysql_query($query);

while($row=mysql_fetch_row($result))
{
echo "<br><br> Table Name:". $row[Name] ."<br />";
}

?>

[Nico]

mysql_fetch_row() returns a numerical array, so $row['Name'] won't exist...

www.php.net/mysql_fetch_row

[End User]

Some simple code that will display all of the tables in a database:

PHP Code:

$alltables = mysql_query("SHOW TABLES");

while ($table = mysql_fetch_assoc($alltables)){

   foreach ($table as $db => $tablename){

      print "Table: $tablename <br />";

   }
} 

[mejnoona]

Thanks that did work. Thats a new fetch command....man, I cant wait til I get to the point where I can write code on the fly and not run into so many steping stones Thanks again!

[mab]

Browsing the relevant section in the php manual is an excellent way to find out what functions are available and what they do - http://us2.php.net/mysql