title: MySQL select where timenow > database time
body: <p>I have a PHP script which creates a new order and inserts the time NOW + 15 minutes into the database.</p>
  
  <p>After 15 minutes have expired the user cannot access the order page.</p>
  
  <p>On the admin panel I only want to show records that have not expired, so my question is what select statement would I use to do this, and which would be the most efficent?</p>
  
  <pre><code>SELECT * FROM `orders` WHERE datenow &gt; date
  </code></pre>
  
  <p>The "date" is the date of the order + 15 minutes</p>
  
  <p><strong>P.S.
  Aternativly, is there any way to do this using PHP so I don't have to put too much stress on the database?</strong></p>
  
  <p>Many Thanks!</p>