Come on, check the mysql section of the PHP manual ... this took about 20 sec
http://www.php.net/manual/en/function.mysql-list-tables.php
At 11:34 PM 3/30/2003 +0300, Antti wrote:
How do I test if a mysql table exists or not? Is there a function for
this? I didn't find a good one.
-antti
--
PHP
use mysql_query(show tables); get them in array and then scan the array
thats what i would do if there isn;t any function
Friendship is always a sweet responsibility, never an opportunity.
HaSeEb IqBaL.
0300-4258030
- Original Message -
From: Antti [EMAIL PROTECTED]
To: [EMAIL
On 30-Mar-2003 Antti wrote:
How do I test if a mysql table exists or not? Is there a function for
this? I didn't find a good one.
-antti
function tableexists($tbl) {
$res = @mysql_query(SELECT 1 FROM $tbl LIMIT 1);
return ($res ? true : false);
}
Regards,
--
Don Read
3 matches
Mail list logo