On 21-Jan-2003 Mako Shark wrote:
> Is there a way of finding if a table exists with only
> one command in MySQL? I've looked through the MySQL
> functions, and the closest I've gotten to what I need
> is mysql_list_tables or mysql_tablename (I'll have to
> check into these a little more), but I was hopefully
> looking for something that returns a boolean value,
> and to be able to use it like:
>
> if(mysql_table_exists("tablename")) {
> ...
> }
>
> Any ideas, short of creating my own function?
>
Create your own, or borrow mine:
function tableexists($tbl) {
$res = @mysql_query("SELECT 1 FROM $tbl LIMIT 1");
return ($res ? true : false);
}
Regards,
--
Don Read [EMAIL PROTECTED]
-- "Beer is proof that God loves us and wants us to be happy."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
