An Sql Problem In Php returnin the name of the tables

[spy_charly 0]

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

[rvalkass 5]

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.