| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Nicolas Verhaeghe | Date: | April 21 2006 6:50pm |
| Subject: | RE: WHERE doesn't work | ||
| View as plain text | |||
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.
-----Original Message-----
From: Tom Lobato [mailto:tomlobato@stripped]
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@stripped
Subject: Re: WHERE doesn't work
Writing echo
"<p>-".mysql_error()."-<P>-".mysql_info()."-<p>";
below
$result = mysql_query($command);
gives the output:
--
-Rows matched: 2 Changed: 0 Warnings: 0-
So, it seems mysql doesnt get error. It simply ignores the WHERE.
>From: "George Law" <glaw@stripped>
>echo mysql_error()."<P>".mysql_info();
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
| 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 |
