Re: Mysql('mydb", "SHOW TABLES FROM mydbname") ???
| From: | Miles Thompson | Date: | Sat, 12 Jan 2002 17:02:27 +0000 |
| Subject: | Re: Mysql('mydb", "SHOW TABLES FROM mydbname") ??? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-80296@lists.php.net to get a copy of this message | ||
Well, did you try looping though tables with mysql_fetch_array($tables)?
But, how 'bout mysql_list_tables()?
Cheers - Miles Thompson
PS There's a bunch of other interesting stuff relating to database manipulation there too. /mt
At 11:48 AM 1/12/2002 -0800, Chris wrote:
I'm trying to display the tables in my database using $tables = mysql('mydb", "SHOW TABLES FROM mydbname") but this statement doesn't seem to behave like selecting records from a table. Does this query return an array of table names? If I use something like $records = mysql('mydb", "SELECT * FROM sometable) everything works fine. There must be something I'm missing about the SHOW query. Thanks Chris Williams -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net