table exists

[drifter]

is there a way to find out if a mysql table exists in my db?

[fert]

[code]
$result=@mysql_query("SELECT `col` FROM `table`",$cn) or die(mysql_error())
if(mysql_num_rows($result)!=0)
{
echo "Table exists";
}
else
{
echo "Table doesn't exist";
}
[/code]
or you could list the tables and search for the table name.

[trq]

use [url=http://php.net/mysql_list_tables]mysql_list_tables[/url]().