title: Keeping a revision history with PHP and MySQL
body: <p>I have a couple tables that I want to keep a revision history on. What is the best way to accomplish this? It's going to be several fields (20 or so). </p>
  
  <p>Should I create a duplicate table and just submit the old data to that? Should I use triggers? Or should I create a separate table and just track the changes made?</p>