title: MySQL: How to get changes of last UPDATE
body: <p>I am working on a database application with MySQL and PHP. At this moment I'm trying to get the changes caused by the last UPDATE. My first way to solve the problem is</p>
  
  <ul>
  <li>getting the 'old' state with SELECT</li>
  <li>Doing the changes with UPDATE</li>
  <li>getting the 'new' state with SELECT</li>
  <li>comparing the arrays with php</li>
  </ul>
  
  <p>These are three mysql-connections...</p>
  
  <p>Is there any way to shorten this?</p>