On Mar 25, 2010, at 5:10 PM, James Colannino wrote:
> Hey everyone,
> I have a question. If I do a mysql query that updates a column in a row
> to the same value, I get 0 rows affected. However, I also get 1 or more
> matched rows. Is there a way that I can return the number of matched
> rows, rather than the number of rows affected?
> I'm trying to get something done with as few SQL queries as possible.
As for as I know, MySQL simply just doesn't report a row as being affected if
nothing has changed in it. To get the number of matched rows, try doing a
SELECT query before you do the UPDATE query. I don't know if that will produce
the results you're looking for, but it might.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php