newbie question

[Anon]

How can i ask somenthing like this to MySQL

---

IF TABLE "named something" exists
{

}

thanks--
im sure this one is very easy..

[Anon]

use mysqlshow or

show tables;

[Anon]

Say,
$db = 'Your mySQL DB name';
$result = mysql_ListTables($db);
$qty = mysql_NumRows($result);
for($i = 0; $i < $qty; $i++) {
$table = mysql_TableName($result,$i);
if (your table name == $table){
Perform ur action here;
}
}