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:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 12:11 PM To: mysql@lists.mysql.com 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" <[EMAIL PROTECTED]> >> 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
