title: Create a MySql job or loop who's constantly checking a field on a table
body: <p>Well i'm currently developping a browser multiplayers game and having some problem about the conception. This is a Ogame like (http://www.ogame.org/) using PHP / Js / MySql.</p>
  
  <p>What i want is that players will launch an action (cut the wood) and this action will be ending in XX minutes. </p>
  
  <p>So basicely my idea was to create an on the fly cron which will launch after XX minutes a SQL query, adding in the DB XX ressources to the player.</p>
  
  <p>Another problem is that players can navigate on the sea with their ship, so if they are moving to a certain destination they will make XX meter each 5 minutes for example.</p>
  
  <p>So the thing is that all the players can see each others on the sea. So basicaly, i can't wait for 10 minutes to add XX meter to the player ship, it have to be done after 5 minutes...</p>
  
  <p>EDIT : So basicely i need a MySql job like or a infinite loop who's constantly checking on a table. This table will contain the end time (timestamp) of all the actions. And so the job have to execute a Sql Query when this time is corresponding to the CURRENT_TIME.</p>
  
  <p>Hope you guys have understood my problem ;)</p>