[Resolved] If Tables Exists

[Frederick]

I need the code that checks if a table exists. I have looked at PHP.net and MySQL.com and can not find anything.

Can someone give me a clue of how to check to see if a table is there or not.

The goal is:
If a table exists, an update will occur, else it will skip that process.

[cahva]

I quess you didnt search hard enough 🙂

Check:
http://fi.php.net/manual/en/function.mysql-list-tables.php

The first user comment has the function you need.

function mysql_table_exists($table, $link)
{
    $exists = mysql_query("SELECT 1 FROM `$table` LIMIT 0", $link);
    if ($exists) return true;
    return false;
}

So in your case you could do for example:

if (mysql_table_exists($table,$link)==true) {
$query="UPDATE $table SET field1='$field1' WHERE id='$id'";
mysql_query($query);
echo 'Updated!';
}
else {
echo 'Table "'.$table.'" doesnt exist!';
}

[Frederick]

I tried that but it did not work. I was playing around by referencing another table that stores enrolled users and that worked.

$enSQL = mysql_query("SELECT * FROM ".$prefix."_enrollment WHERE testID=$testID AND aID=".$a["aID"]." ",$dblink)
or die(mysql_error());
if (mysql_numrows($enSQL)) {
    while ($temp = mysql_fetch_array($sql)) {
        $str = addslashes($question);
        $uSQL = mysql_query("UPDATE ".$a["aID"]."_".$testID." SET attachmentType='$attachmentType', attachment='$attachment', question='$str', answer='$answer' WHERE buildID=$id",$dblink)
        or die(mysql_error());
    }
}

Thanks for the feedback, maybe this will help others.

[dbchip2000]

What if you tried this

function mysql_table_exists($table) {
     $tbl=@mysql_query("SELECT 1 FROM ".$table." LIMIT 0");
     if (mysql_error()!="") {
          return false;
     } else {
          return true;
     }
}

I think it would work