[Resolved] mysql_affected_fields?

[perpetualshaun]

Does anyone know of a way that I can find out what FIELDS were affected on an update? If I update 5 fields in the table but really onle one of them changes, is there a way to capture that information w/ some sort of function?

I know that mysql_affected_rows will return the number or records that are updated, but I'm looking for a little more.

Any ideas?

Thanks,

Shaun

[mourisj]

Select the rows to be updated in a temporary table before update; compare with data after update.

Thats the only idea I have about this!

I guess this is not a very comfortable way to to what you want .

At business we use a database which achieves something like this in shadow-tables (Oracle, update/insert/delete triggers). But these data are only used in case of problems, to track changes of critical data. The data are not compared "online". It also tracks date, time, username etc. for every row.

BTW, why would you like to know what fiels have been updated?

Regards,

JJ Mouris