 | | | Another error message problem... | Another error message problem... 2007-12-03 - By Randy Clamons
Back
Hey David,
Your error message problem seems to be mostly PHP, and partially your
sql syntax. When you use mysql_query with a 'DELETE' statement, you will
get either a TRUE for success or FALSE if the query failed.
You need to spend a little time learning PHP logic structures and
syntax. Your statement:
elseif ($ok1 OR $ok2 OR $ok3 == 0)
will be true when $ok1 is true, or when $ok2 is true or when $ok == 0. I
don't think that's what you intended. You probably meant:
elseif (!$ok1 OR !$ok2 OR !ok3)
Next problem is your first query:
"DELETE joke, jokecatagory
FROM joke, jokecatagory
WHERE jokeid = joke.id AND authorid = '$id'");
Your syntax is incorrect, so this query will always return FALSE when
use in mysql_query function. You cannot delete from two tables in a
single statement, if that's what you are trying to do.
Randy Clamons
Systems Programming
randy@(protected)
grovesdavid@(protected) wrote:
> 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)
|
|
|