| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Tom Lobato | Date: | April 20 2006 5:32pm |
| Subject: | WHERE doesn't work | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • WHERE doesn't work | Tom Lobato | 20 Apr |
| • Re: WHERE doesn't work | Barry | 21 Apr |
| • Re: WHERE doesn't work | Peter Brawley | 23 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 23 Apr |
| • Re: WHERE doesn't work | Peter Brawley | 23 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 23 Apr |
| • RE: WHERE doesn't work | Jay Blanchard | 20 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 20 Apr |
| • RE: WHERE doesn't work | George Law | 20 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 21 Apr |
| • RE: WHERE doesn't work | Nicolas Verhaeghe | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 21 Apr |
| • RE: WHERE doesn't work | Nicolas Verhaeghe | 21 Apr |
| • RE: WHERE doesn't work | Nicolas Verhaeghe | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 21 Apr |
| • RE: WHERE doesn't work | Nicolas Verhaeghe | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 22 Apr |
| • Re: WHERE doesn't work | Michael Stassen | 22 Apr |
| • RE: WHERE doesn't work | Nicolas Verhaeghe | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 21 Apr |
| • RE: WHERE doesn't work | Jay Blanchard | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 21 Apr |
| • Re: WHERE doesn't work | Tom Lobato | 24 Apr |
