Forum Moderators: coopster

Message Too Old, No Replies

php/mysql how do I query a list of tables

how does one query a list of mysql tables in a database

         

zRonin

6:50 pm on Jun 23, 2005 (gmt 0)

10+ Year Member



How do I fetch a list of tables in a mysql database?

jatar_k

7:01 pm on Jun 23, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



[php.net...]

coopster

2:40 pm on Jun 25, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



That function is deprecated though, jatar_k.


This function deprecated. It is preferable to use mysql_query() [php.net] to issue a SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] statement instead.

zRonin, an example snippet can be reviewed in this thread regarding MySQL Tables Array? [webmasterworld.com]

jatar_k

4:05 pm on Jun 26, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



>> deprecated

I often forget to look at that, thanks coop