Ok I am close here but need help

[TJaaaay]

I want to use the Mysql SHOW TABLES to fill an array with my table names then loop through them to see if a table exists.

$array = mysqlquery(show tables)
do while array
if rowvalue = mytablename
$exists = 1
else
$exists = 0

Now the problem is I can not get the syntex right

anyone help a noob?

TJay

[Frederick]

http://us2.php.net/manual/en/function.mysql-list-tables.php