I have a multi-column customer master file for which to update I have created a lengthy form. I retrieve and display on the form info from the record to be changed. I invite the user to enter the changed fields and submit the form.

Now I need an efficient way to detect what fields changed and validate the only the new input data, then update only those fields.

Any help greatly appreciated - I am a novice, just learning PHP and MySQL.

leopardj,
in my Experience i did not do this type work, we can check each one by one, but if you found a solution let me know,

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

why don't you update the whole form, all the time, using one standard update query for all the form and all the table fields together?
It would save you some time!

Visit my page: http://www.webrickco.com