|  | Posted by Tyno Gendo on 04/10/07 14:04 
Two questions in a row.. I'm on a roll :)
 When i perform UPDATEs in my admin system, I'm checking for success by
 using mysql_affected_rows() and this works fine if data is changed and
 updated.
 
 However, if a user submits an admin page without chaning any details,
 the SQL executes fine, but mysql_affected_rows() returns 0 as MySQL is
 clever enough to work out that nothing changed.
 
 How do people deal with this?  It hampers my error check as
 mysql_affected_rows() can be 0 for a perfectly valid update.
  Navigation: [Reply to this message] |