checking for existance of a table.

[turnipofdoom]

In a mod I am writing I use this query:


SELECT count(*) cnt
FROM information_schema.tables
WHERE table_schema = '$db_tmp_name'
AND table_name = '".TABLE_PREFIX."mytable'";


db_tmp_name is set properly before the query, it works fine on my dev machine, however I asked someone here to beta test it, and he got table doesnt exist error. So does someone have a fool proof method to check weather a table exists for mysql4 ?

[Paul M]

The query SHOW TABLES will list all the tables in a database - load them into an array and then use in_array() to check if a table exists.