RE: WHERE doesn't work

[Nicolas Verhaeghe]

Ok but what is the problem then?

In the case of a group, you need to use "HAVING" for a condition on a listed
field, and if you "id" is an integer, then you may want to drop the '

Also are you taking care of converting the single quotes or do you have
magic quotes set to on?

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



    Yes, but this output indeed was generated when I made no changes in the 
loaded fields of the web form. When I change something it outputs Changed: 
2, for the case of 2 records in the table.

>>From: "Nicolas Verhaeghe" <nicolas@stripped>
>> Normal. MySQL returns 0 changes when the data before and after the
>>UPDATE
>> is
>> the same.
>
> --
> -Rows matched: 2 Changed: 0 Warnings: 0-


    Tom 


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