[Deansatch]

I have a little problem. I have some code that works great, but when the user deletes a certain item from another part of my site he automatically deletes the table used in this script until he assigns a new table to it.
So, basically I want the script to run only when the table it asks for is present and if it is not present I just want it to ignore this part of the script and carry on with the rest of the page.

PHP Code:

$connection = mysql_connect($host,$usr,$pwd);

$getcontent = mysql_db_query($db, "SELECT * from table_home where id='1'", $connection);

$row = mysql_fetch_array($getcontent);

$gigid = $row["gigid"];



if ($gigid >=1 ){

$todaysdate = date("Y-m-d");



$connection = mysql_connect($host,$usr,$pwd);

$getcontent = mysql_db_query($db, "SELECT * from table_$gigid WHERE date >= '$todaysdate' ORDER BY date asc", $connection)or die(mysql_error());

$row = mysql_fetch_array($getcontent);

$date = $row["date"];

$date1 = date("l dS F Y", strtotime($date) );

$venue = $row["venue"];

$address = $row["address"];

$time = $row["time"];

$tickets = $row["tickets"];

if ($date >= $todaysdate ){





$filename = "nextgig.html"; 

$handle = fopen ($filename, "r"); 

$contents = fread ($handle, filesize ($filename));

$contents = str_replace(XdateX, $date1, $contents);

$contents = str_replace(XvenueX, $venue, $contents);

$contents = str_replace(XaddressX, $address, $contents);

$contents = str_replace(XtimeX, $time, $contents);

$contents = str_replace(XticketsX, $tickets, $contents);

fclose ($handle); 

print($contents); 

}

} 

basically I want to add something like "if table_$gigid exists" after "if ($gigid >=1 )"

any ideas??

[mab]

Try something like this -

PHP Code:

$query = "EXPLAIN table_$gigid";

$result = @mysql_query($query);

if ($result){

echo "table exists code here";

} else {

echo "table does not exist code here";

}