 | | | Another error message problem... | Another error message problem... 2007-12-03 - By Leif Johnston
Back
You need to spend time in the query manual...
Simple look at it sugests that you are misusing your "if" syntax since you
would evaluate to if "$ok1" evaluates to true, and "$ok3" evaluates to 0
Besides that, you have to be killing performance for ease of readability...
Take some time and learn the language and think about what you are really
trying to do and how that maps to the language... Queries should be pooled
where possible rather than clung together, comparisons need to be clean and
individually managed, etc.
After that you will have code that is much more likely to reflect your
intentions.
Leif
Leif Johnston
Managing Partner
Technology Catalyst, LLC
www.TechnologyCatalyst.com
-- --Original Message-- --
From: grovesdavid@(protected)
[mailto:grovesdavid@(protected)]
Sent: Monday, December 03, 2007 8:16 AM
To: win32@(protected)
Subject: Another error message problem...
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=leif@(protected)
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
|