From: Peter Brawley
Date: April 23 2006 4:03am
Subject: Re: WHERE doesn't work
List-Archive: http://lists.mysql.com/mysql/197216
Message-Id: <444AFCA8.8090603@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Tom,

 >   UPDATE command is not working for only the record that I want, but for
 >all in the table. I sees WHERE is not interpretated by Mysql server. At
 >least the result is identic to it. For example, If my php execute

 >           UPDATE clientes SET tipo='r', nome_fantasia='cc', estado='24'
 >WHERE id = '5'

With a previous message you posted attachments which turned out _not_ to 
be the PHP code which you say is not working.

If you want help with this problem, you will have to post the minimal 
table data and PHP code needed to demonstrate your difficulty. Otherwise 
this discussion appears to be going nowhere.

PB

-----

Tom Lobato wrote:
>
>    Hi!
>
>
>    UPDATE command is not working for only the record that I want, but for
> all in the table. I sees WHERE is not interpretated by Mysql server. At
> least the result is identic to it. For example, If my php execute
>
>            UPDATE clientes SET tipo='r', nome_fantasia='cc', estado='24'
> WHERE id = '5'
>
> on the server, I have all records in the table clientes updated for these
> values. But, if I copy exactily this command from php output and 
> execute in
> the Mysql server directly, via some mysql client, it updates only record
> whose id = '5'. PHP Version: 4.4.2, Mysql client API version: 3.23.49.
> For windows servers or Linux.
>    Some Hint?
>
>
>
>    Thank you
>    Tom
>
>


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.5/321 - Release Date: 4/21/2006