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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
