rwreplog

I am working on a database driven registration software I created for the school corporation that I work for. It is coded in PHP, and is tied to a MySQL database storing all of the information for the students within the corporation. The program is set up so that each student has a log in account, and once logged in, their demographics and etc. are displayed on the screen. If all the data looks correct they click on 'confirm' and it stores a variable in the database to show that the data was confirmed. However, if a field needs to be changed and updated, it is set up so that all the fields then become editable, and after being changed the user clicks 'save changes' and once again, a variable is stored in the database to show that the user made a change to their data. The administrator account, when logged in, gives the administrator the opportunity to pull up the entire database showing only the students who had made a change to their account, and it displays the demographic information stored within their profile. My question is, is there a way that I can make this table only show the fields that were actually changed, instead of all of the information stored in their account? Would I have to include a timestamp for each individual field, and have the administrator's page call up only fields that have the timestamp marked on them? Is there any scripts that would assist me in this? I have been searching all week, and decided to join a forum to test my luck further! Thanks in advance for any help!