Re: [PHP] Mysql('mydb", "SHOW TABLES FROM mydbname") ???

2002-01-12 Thread Miles Thompson
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

[PHP] Mysql('mydb", "SHOW TABLES FROM mydbname") ???

2002-01-12 Thread Chris
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