 | | | Another error message problem... | Another error message problem... 2007-12-03 - By -not available-
Back
Hello,
I've deliberately left the look up table blank, to test if :
elseif ($ok1 OR $ok2 OR $ok3 == 0) {
echo '<p> No entries found to delete </p>';
}
Works in the query below, it doesn't... I'm using MySQL 4.0.4 beta on my
testing server... I really am having a lot of problems getting these error
messages to work correctly. What the heck am I doing wrong.....
$id = $_GET['id'];
$ok1 = mysql_query(
"DELETE joke, jokecatagory
FROM joke, jokecatagory
WHERE jokeid = joke.id AND authorid = '$id'");
$ok2 = @(protected)(
"DELETE FROM joke WHERE authorid = '$id'");
$ok3 = @(protected)(
"DELETE FROM author WHERE id = '$id'");
if ($ok1 and $ok2 and $ok3) {
echo '<p> Author deleted successfully!</p>';
}elseif ($ok1 OR $ok2 OR $ok3 == 0) {
echo '<p> No entries found to delete </p>';
}else{
echo '<p> Error delecting author' . 'Error: ' . mysql_error () . '</p>';
}
Kind Regards
David)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
|