 | | | Another error message problem... | Another error message problem... 2007-12-03 - By Anders Karlsson
Back
Randy!
Actually, in MySQL you can delete from more than 1 table with 1
statement. This is a MySQL extension which is not much used, at least I
haven't seen it used much, but it is there. So the DELETE syntax is
probably correct (I say probably as I don't know the schema). See more
here: http://dev.mysql.com/doc/refman/5.0/en/delete.html
That said, I agree with what others have said on this subject
/Karlsson
Randy Clamons wrote:
> 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)
>>
>
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson (anders@(protected))
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 708 608121
Skype: drdatabase
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
|