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?

Add hidden fields for each entry box and toggle them between false/true or 0/1 with javascript using the onchange event.

then test for the field having been changed before concatenating the query.

One could just select the data again after the form is submitted, and then compare the form data to the data from the DB.