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.
> Thanks!
> James

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.

Take care,

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to