PHP Functions Essential Reference

mysql_list_tables

mysql result mysql_list_tables(string database, [mysql link connection]) 

database	Database to use
connection	Connection handle returned by mysql_connect() or mysql_pconnect()

Lists the tables in a MySQL database.

Returns:

MySQL result handle; FALSE on error

Description:

mysql_list_tables() fetches a list of the tables that comprise the given database and returns a MySQL result handle that can be traversed with mysql_result().

If the connection argument is not set, the last connection opened is used by default. If no connection is open, mysql_list_tables() attempts to connect to a MySQL database by calling mysql_connect() without arguments.

Version:

PHP 3+, PHP 4+

See also:

To gather information on the databases on a MySQL ...