Okay what the hell I'm bored anyway...
function mysql_table_exists($table)
{
global $db; // <- database resource handle
$result = @mysql_list_tables($db);
if (mysql_num_rows($result) > 0)
{
while ($row = mysql_fetch_row($result))
{
if (strtolower($row[0]) == strtolower($table)))
{
return true;
}
}
}
return false;
}
Untested but it's pretty basic stuff so I'm certain it works. Enjoy!
-Kevin
----- Original Message -----
From: "Mako Shark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 10:05 AM
Subject: [PHP] Finding out if a table exists
> 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?
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
