| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jay Blanchard | Date: | April 20 2006 5:35pm |
| Subject: | RE: WHERE doesn't work | ||
| View as plain text | |||
[snip]
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?
[/snip]
More of a PHP question. Echo the UPDATE statement to the browser so that
you can see what it looks like.
| 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 |
