title: How do I SELECT only rows that are greater than today's date and time?
body: <p>Forgive me if this is a simple question, but I am trying to echo out rows that are only in the future, ie: greater than today's date and time. This is my code so far:</p>
  
  <pre><code>$date = date('Y-m-d');
  $time = date("G:i:s", time());
  
  $eventsquery = "SELECT * FROM events as A WHERE tech='$userecho' AND date &gt;= '$date' ORDER BY date ASC, time ASC";
  $eventsresult = mysql_query($eventsquery, $eventsdbhandle);
  </code></pre>
  
  <p>This works great for giving me rows that are either for today or in the future,
  This problem is, this will give me entries that happened before the current time on the current day. So I tried adding this: </p>
  
  <pre><code>$eventsquery = "SELECT * FROM events as A WHERE tech='$userecho' AND date &gt;= '$date' AND time &gt;= '$time' ORDER BY date ASC, time ASC";
  </code></pre>
  
  <p>But I get no rows at all. I know this is likely an easy fix, but I have found nothing on this site that fixes it. Any help would be great. </p>
  
  <p>Time in the table is stored in this format: hh:mm:ss ie: 14:23:12</p>