Hi Ron, Look at the mysql_list_tables function, it looks like it will provide what you are are looking for.
http://www.php.net/manual/en/function.mysql-list-tables.php is the link to the manual Jason -----Original Message----- From: Ron Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:02 PM To: [EMAIL PROTECTED] Subject: [PHP] Help with showing tables in DB -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Consider the following: mysql_select_db($db_name); $result = mysql_query("show tables"); while ($rows = mysql_fetch_object($result)) { echo $rows; } So why does this not return the Table names? I have even tried "echo rows->Table" and "echo rows->Tables" to no avail. So how do I fix this? Thanks in advance, Ron C. -----BEGIN PGP SIGNATURE----- Version: PGP 7.1 iQA/AwUBPHv32kSpEYIqgLQzEQISfQCeLVinx7oQc4Gmudv1MJbb17dGCPoAnA7S yRR86rJUwHsXGJlU0yVckVyK =2bva -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php