 | | | Another error message problem... | Another error message problem... 2007-12-03 - By Randy Clamons
Back
Well, I try to learn something every day. I guess I can go home now :)
Then again, I've been doing this the hard way for a long time now. Maybe
I should stay a while and RTFM myself. Thanks for pointing this out.
The remaining problems are really in the PHP code, not the query syntax.
Randy Clamons
Systems Programming
randy@(protected)
Anders Karlsson wrote:
> 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)
>>>
>>
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
|
|
|