Table question

rakennedy75

Is there a quick and easy function that will check to see if a table exists before I acitvate a script. Kind of like file_exists works for a file I would like to check a table.

Thanks

tekky

<table> table or MySQL table? need to be a bit more specific when asking for help 😉

rakennedy75

Sorry. A mysql table. I am dropping a table and creating a new table but if the table doesn't currently exist I don't need to drop it so I want to see if it currently exists otherwise I get an error.

Thanks

sy-co

you can supress the error using @

$result=@(select id from table)

$var=@mysql_result($result,$i,id);

test for the value of $var using isset

if (isset($var)) {

drop table
create table

}
else
{
create table
}

I havent had the need to do this but i guess you could just isset($result) and save yourself a line of code.

I hope thats what you were looking for.

tekky

from PHP.net under mysql_tablename

//Another way to check if a table exists:

if(mysql_num_rows(mysql_query("SHOW TABLES LIKE '".$table."'"))==1) echo "Table exists";
else echo "Table does not exist";

rakennedy75

That will work. I guess there isn't a simple function such as there is for file_exists but that is simple enough. Thanks a lot guys for your input.