title: How to make a reminder in mysql with date stored in unix_timestamp
body: <p>Please I am making a reminder to start sending mails for events starting in 7 days or less.
  That is send mails to attendees to events starting in 0 - 7 days only.</p>
  
  <p>Where I need help is on this line:</p>
  
  <pre><code>...WHERE event_start_date &gt; '$current_time' //currently sends to all attendees for all events starting in future
  
  $current_time = time();
  </code></pre>
  
  <p>How can I change that to reflect what I need?
  Kindly note date is stored in unix_timestamp.</p>
  
  <p>Thank you</p>