An Sql Problem In Php returnin the name of the tables

hello again guys!, i was wondering if there is a way to get the table names from my database using php. Well what i want to do is to get the name of the tables returned as an array or something similar...thanx in advance

You can use an SQL command to list all of the table names in a database.

For example:

<?phpmysql_connect(localhost,username,password);$query = "SHOW TABLES FROM database";$tables = mysql_query($query);?>

The variable $tables will then contain all of the names of the tables.

Hope this helps you.