How to get a list of tables from MySql?

[Anon]

I use php and sql to manage my db (from create tables, to regular managements).

I can do pretty much anthing, but is there a way to get a list of tables in an db with php? (combine with sql query?)

Thanks in advance.

[alan_d]

hi

pass 'show tables' to mysql_query() as the query argument. Unpack the result in any of the usual ways:-

$connection_id = mysql_connect();

mysql_select_db(db_name, $connection_id);

$result = mysql_query('show tables');