title: Before Update Trigger in Phpmyadmin how to get updated values
body: <p>I'm trying to get a trigger in phpmyadmin which would create a audit with a certain column value (<code>reputation</code>) before and after the update of a specific table.</p>
  
  <p>Something like:</p>
  
  <pre><code>CREATE DEFINER=`test`@`%`
  TRIGGER `monitor update reputation`
  BEFORE UPDATE ON `game_resorts`
  FOR EACH ROW
  INSERT INTO `audit` (`id`, `datetime`, `id_resort`, `reputation`)
  VALUES (NULL, CURRENT_TIMESTAMP, id_resort, reputation)
  </code></pre>
  
  <p>The main question is how can I retrieve the <code>id_resort</code> which will be updated; and then, the <code>reputation</code> value?</p>