Check if table exists

[Fire Juggler]

On my website, the user can create tables, but how do i check if the table
exists, and if it doesn't it creates the table?
Thanks

--
Kathryn (Fire Juggler)

http://www.firejugglers.34sp.com

http://www.cornwalljugglers.co.uk

[Tony]

Re: Check if table exists

Fire Juggler wrote:[color=blue]
> On my website, the user can create tables, but how do i check if the
> table exists, and if it doesn't it creates the table?
> Thanks[/color]

I don't know about other DD's but in MySQL:

IF NOT EXISTS - see the page on CREATE TABLE syntax in the MySQL manual:

http://dev.mysql.com/doc/mysql/en/create-table.html

--
Tony Garcia
Web Right! Development
Riverside, CA

https://www.WebRightDevelopment.com