List:General Discussion« Previous MessageNext Message »
From:Nicolas Verhaeghe Date:April 21 2006 6:50pm
Subject:RE: WHERE doesn't work
View as plain text  
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.

-----Original Message-----
From: Tom Lobato [mailto:tomlobato@stripped] 
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@stripped
Subject: Re: WHERE doesn't work


Writing echo
    "<p>-".mysql_error()."-<P>-".mysql_info()."-<p>"; 
below 
    $result = mysql_query($command);
gives the output:

-- 
-Rows matched: 2 Changed: 0 Warnings: 0-


So, it seems mysql doesnt get error. It simply ignores the WHERE.



>From: "George Law" <glaw@stripped>
>echo mysql_error()."<P>".mysql_info();


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
WHERE doesn't workTom Lobato20 Apr
  • Re: WHERE doesn't workBarry21 Apr
  • Re: WHERE doesn't workPeter Brawley23 Apr
  • Re: WHERE doesn't workTom Lobato23 Apr
    • Re: WHERE doesn't workPeter Brawley23 Apr
  • Re: WHERE doesn't workTom Lobato23 Apr
RE: WHERE doesn't workJay Blanchard20 Apr
  • Re: WHERE doesn't workTom Lobato20 Apr
RE: WHERE doesn't workGeorge Law20 Apr
Re: WHERE doesn't workTom Lobato21 Apr
  • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
    • Re: WHERE doesn't workTom Lobato21 Apr
      • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
      • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
        • Re: WHERE doesn't workTom Lobato21 Apr
          • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
            • Re: WHERE doesn't workTom Lobato22 Apr
              • Re: WHERE doesn't workMichael Stassen22 Apr
  • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
Re: WHERE doesn't workTom Lobato21 Apr
Re: WHERE doesn't workTom Lobato21 Apr
Re: WHERE doesn't workTom Lobato21 Apr
RE: WHERE doesn't workJay Blanchard21 Apr
  • Re: WHERE doesn't workTom Lobato21 Apr
Re: WHERE doesn't workTom Lobato24 Apr