table names retrieval

[Anon]

Is it possible to retrieve all the names of the tables in a database?

My problem is that I need to make an array with the list of database table names and I would think this would be much faster than manually doing it :-)

[Anon]

Try:

$result = mysql_list_tables($dbname);

while ($myrow = mysql_fetch_row($result)) {
print $myrow[0] ."<br>";
}