Making Save Points

[scouse]

Hi,

I'm creating an admin section for one of my websites which allows the user to edit/manage the content of their website.

The process would be:

select page to edit > edit content > click save > content is live on website

However, I need there to be three save points (or restore points), so if they make a mistake the user can just select an earlier version, click save and the earlier version would now be live on the site. The other two remaining save points would be the last two most recent saves.

The only problem is that I'm having a little trouble getting my head around it and was wondering if anyone could suggest how's best to approach it.

Cheers

Phil

[wmif]

this data is going into a database?

[scouse]

Sorry, I forgot to mention that bit :rolleyes:

The data is stored in a mySQL database.

I was thinking that I could just write to the database into a new row everytime somone saves and then just use the last three rows of the database for my save points. But I don't think this will be the most efficient way of doing it.

Phil

[wmif]

i would do what you are saying, but add a date, or a status column.