Re: mysql_affected_rows inaccurate?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, February 15, 2007 10:06 am, altendew wrote:
>
> Hi a long time ago I stopped using mysql_affected_rows because I
> believed it
> was giving me an inaccurate number. Now I was not very knowledged then
> so it
> could of been my own fault. Is this function safe and functional?
> Could it
> possibly give me the row result of a previous query I did and not the
> latest?

Works for me.

It only counts rows that ACTUALLY CHANGED and not the number of rows
that fit your WHERE clause.

This can be confusing at first, but is quite useful, particularly for
marking records "dirty" when you want to re-publish a record only if
it really really changed in a large database -> static publishing
setup.

http://php.net/mysql_affected_rows

-- 
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux