knowing whether mysql table exists

[math]

Hi,

As my title suggests, How can I find out whether a table is my mysql database exists? if not, I have to create it, if it exists I can use it...

I need to know this because I have to use dynamic tablenames in my database...

Is there a way to search for a tabelname?
$exists = mysql_table_exists($tablename); ????????

or something??

Thanx in Advance,
math

 

[Glowball]

The functions listed at

http://www.phpbuilder.com/manual/ref.mysql.php

can probably help you out.

mysql_list_tables()

will give you all table names that you could go through, or you could try connecting to the table in question and checking for an error.