Checking whether a table exists!!

[Anon]

Hi,

Does anybody know whether it is possible for a PHP script to check if a table exists in MySQL?
My idea is that if it does exist then the script would add data to it, if not then a table would be created.

Hope this makes sense!!!

Cheers

Mike

[Anon]

Hrmm.. the only hack I could see for this would be the following:

$dbh = mysql_connect('localhost','user','pw');
$res = mysql_query('SELECT * FROM myTable');
if (mysql_errno() > 0) { # If there is an error, we will assume the table doesn't exist
mysql_query("CREATE TABLE myTable (etc etc)");
}
mysql_query("INSERT INTO myTable VALUES (1, 2, 3)");

That should do it..

Chris

[Anon]

have a look at mysql_list_tables() and mysql_tablename()

--
rad