Or...
function mysql_table_exists($table)
{
mysql_query("use $table");
if(mysql_error()) { return false; }
else { return true; }
}
---John Holmes...
----- Original Message -----
From: "Kevin Stone" <[EMAIL PROTECTED]>
To: "Mako Shark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 1:05 PM
Subject: Re: [PHP] Finding out if a table exists
> 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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
