title: How to keep history of record updates in MySQL?
body: <p>I have to create a code in PHP that will allow me to keep the history of record updates in MySQL database so I can find by date an old revision.</p>
  
  <p>Here is the example of what I actualy want to achive:
  <a href="http://en.wikipedia.org/w/index.php?title=Tunisia&amp;action=history" rel="noreferrer">http://en.wikipedia.org/w/index.php?title=Tunisia&amp;action=history</a></p>
  
  <p>The data are mostly Numbers that we record about the company to generate reports and to extract indices.</p>
  
  <p>I plan to use codeigniter for it's simplicity and I'm looking for idea about a framework or an opensource project that use the same approach to keep history of modifications in the database.</p>