Simple SHOW TABLES snippet

[jester626]

Anyone have a small snippet of code on how to use SHOW TABLES inside of PHP?

Thanks in advance

[AndyB]

[code]mysql_select_db("foobar");
$query = "show tables";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
print "There are $num_results tables.<br>";
for ($i = 0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($result);
print "table " . $row[0] . " exists.<br>";
}[/code]

http://dev.mysql.com/doc/refman/5.0/en/show.html