> I mean, if I send an update query, like "update table set
> field1=$nfield1, field2=$nfield2 ...", I don't know WHICH fields have
> changed. mysql_affected_rows() only reports how many records were
> changed. So, if I want to know which fields have changed, I should
> it before I send the query? Seems like a lot of work extra...
Well, that's the only way to do it. If you want to know what changed,
SELECT it out first and compare. UPDATE commands do not return that
information, plain and simple. Worrying about it is a waste of time.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php