Help in keep records while updating the records

I need Help in keep records while updating the records. My prob is that
i cant able to keep the version of records. i m working on a website
project. For that purpose we hav to keep the version of records. each
time update the record it will update it that for sure but it will also
keep the duplicate cate copy of the record tht is being updated.
in out table we have "ID" as primery key and "version" as another
unique key
I m trying that when ever i update the record it will keep the backup
of the record is being updated and also updates the record.
the updated record has updated on the "version" field nt the "ID" field

Re: Help in keep records while updating the records

I would recommend to create another table to track the history of
updates.

This new table could grow with new entries containing the ID and old
information before update.
It could also hold a date field to track exactly when it was updated.

This will support your current design with the original table being the
most up-to-date information, plus you will be able to list the history
for any entry using the 2nd table.