title: How to retrieve data from a mySQL database based on current month using the [DATE] function?
body: <p>Okay so am using this structure in my SQL database:<br></p>
  
  <pre><code>id  |  title  |   date_start   |   date_end|  time_start   |   time_end   |   location   |
  </code></pre>
  
  <p>I am wanting to sort data from that table, but only the upcoming dates or dates that are currently occurring.</p>
  
  <p>I've used the following query in php:</p>
  
  <pre><code>$query = mysql_query("SELECT * FROM events3 ORDER BY date_start DESC LIMIT 5");
  </code></pre>
  
  <p>Then after the query I fetched the results, then echoed them as so:</p>
  
  <p><a href="http://pastebin.com/5wS7npsr" rel="nofollow">http://pastebin.com/5wS7npsr</a></p>
  
  <p>That would display the only two dates in the database as:</p>
  
  <pre><code>ID:   2
  Title:   New Years Eve
  Date Start:   2012-12-31 - 2012-12-31
  Time Frame:   12:00:00 - 12:00:00
  Location:   Earth
  Description:   The last day of 2012.
  
  
  ID:   1
  Title:   Christmas Day
  Date Start:   2012-12-25 - 2012-12-25
  Time Frame:   12:00:00 - 12:00:00
  Location:   Earth
  Description:   Merry Christmas!!
  </code></pre>
  
  <p>But I want it to expire after the date has occurred and only show the next upcoming ones.</p>