Is there a way to find out if a table exists?

[Dan Anderson]

I am trying to make my PHP script autodetect when a table in a mySQL
database exists, and when it doesn't, create it.  

Is there some way to do something like:

SELECT * FROM tables WHERE name = "table_name";

And get a result I could test for truth, and thus run my script?

Thanks in advance,

Dan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]