Re: [PHP-DB] mysql_affected_rows() question: what was changed?

2003-03-20 Thread Edwin Boersma
Not really true, unless I learned programming in a different way ;-) 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

RE: [PHP-DB] mysql_affected_rows() question: what was changed?

2003-03-20 Thread John W. Holmes
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 check it before I send the query?

[PHP-DB] mysql_affected_rows() question: what was changed?

2003-03-18 Thread Edwin Boersma
Hi, Is there a function to show WHAT fields were changed in the records, instead of only how many records were changed (with mysql_affected_rows())? I would like to report to the user which fields were altered, e.g. if he would change his phone number, to tell him: phone number changed to