Let's say I have a form populated with data pulled from a database. If someone overwrites one of the fields and clicks "submit", the script compares each piece of data with the original, and determines which values have changed. That's where I could use some help. I can see two options. 1. Submit an update query to update all fields, even the ones that didn't change. That would make it appear that all fields were updated, and make it hard to determine what was changed, and when. 2. Create a dynamic update query that only includes the items updated. I think option 2 would be best, but I am not sure how to build a dynamic update query that only includes "changed" values. I have looked around the web, and cannot find any answers. I probably don't know the correct verbiage to type into a search engine. Would someone be willing to provide me with some direction, or point me to some resources where I can find the answer myself?
Read the MySql manual and you have your answer. http://dev.mysql.com/doc/refman/5.0/en/update.html If you set a column to the value it currently has, MySQL notices this and does not update it.