, |
$dbcnx = @mysql_connect('mysql.plainhost.com','ecosmar_ecosmart','ecoman1');
mysql_select_db('ecosmar_contacts', $dbcnx);
$ok = @mysql_query("DELETE FROM con_reactivity WHERE CID='$CONID' AND dtnum='$dtnum' LIMIT 1");
if (!$ok){
echo("Error deleting Reactivity!".
"Error:" . mysql_error() . " |
");
}
$sql = "OPTIMIZE TABLE con_reactivity";
if(!$sql){
echo("Problem Optimizing Reminders " .
"Error:" . mysql_error() . " |
");
}
mysql_select_db('ecosmar_friendly', $dbcnx);
$ok2 = @mysql_query("DELETE FROM calendar WHERE usrn='$usrn' and dtnum='$dtnum' LIMIT 1");
if (!$ok2){
echo("Could not delete Calendar Info".
"Error:" . mysql_error() . " |
");
}
$sql2 = "OPTIMIZE TABLE calendar ";
if(!$sql){
echo("Problem Optimizing Calendar " .
"Error:" . mysql_error() . " |
");
}
$ok4 = @mysql_query("DELETE FROM dates WHERE ID='$ID'");
if (!$ok4){
echo("Error Deleting Event!".
"Error:" . mysql_error() . " |
");
}else{
echo("Successful Deletion! |
");
}
$sql3 = "OPTIMIZE TABLE dates";
if(!$sql){
echo("Problem Optimizing Dates " .
"Error:" . mysql_error() . " |
");
}
?>
Return
|