[eluser]nextexile[/eluser]
Users need to be able to make changes to a record but we need to internally save it as a new one to keep a history of changes.
Should I be using a simple timestamp or a revision column that gets incremented?
In case of timestamp I could just order by date desc and limit to 1 to get single latest record.
If I wanted to go with a revision number though, how would I pull latest revision on multiple records in one query?
Should I just stick to timestamp method?