insert data to table that has been modified ONLY.

[poe]

i have a user(members) form that pulls from my database 3 fields: name, age, about.

 

i want the user to be able to edit their info then re-submit back to the database.

 

however, i want to have some control as to what they edit their info to. so instead of just update the info back to the database, i want to hve any fileds that have 'changed' by the user get put to a different table(review), so after i have approved the changes i will 'update the master user table.

 

is there a logical way that i could do this, i guess just flag any fields that have changed when the user form is submitted.

[rameshfaj]

Certainly u need two tables,name them a/c to ur convention and insert each change to each user name or id in the next table and the administrator can be informed or can manually check the entries for the particular username and if valid can update the entries and send the confirmation to the user after decided that it is valid.

It is better to manage some norms that will update the data and validate and update immediately rather than waiting the administrator to update that info,bcoz sometimes immediate access thru changed info(like password) is required and the admin cant be logged in 24 hours and check,but the code and logic always for u to help in that situation.