Paul DuBois schreef: > UPDATE tbl_name SET col_name = 0 WHERE col_name = 0; > > If you've selected the rows-changed count, $sth->rows() will always > return 0, because the statement doesn't actually change any col_name > value from its current value.
That would be an odd optimization. The update should take place, even if the value wouldn't seem to change anything. Hidden fields like "record last updated", or triggers, could depend on this. -- Affijn, Ruud "Gewoon is een tijger."