Posted by Arjen on 04/10/07 14:25

Tyno Gendo schreef:
> 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.

Wrong and .. wrong. There is no perfectly valid update and you are not
checking for errors :-)

Add a field time(timestamp) and update "... time = NOW(), ... etc"

--
Arjen
http://www.hondenpage.com - Mijn site over honden

[Back to original message]