title: mysql query for upcoming event with start date and end date and show past event
body: <p>I have a event table which start and end date stored like follows</p>
  
  <pre><code> event_id   eventstartdate    eventenddate 
      1       2012-10-02         2012-10-20 
      2       2013-09-27         2013-10-27 
      6       2013-10-18         2013-11-18 
      8       2012-11-06         2012-11-23 
      9       2013-02-05         2013-02-12 
      10      2013-06-11         2013-06-13 
  </code></pre>
  
  <p>and i want to show the event order by the event start date from today..and get the past event based on the event start date in single query..</p>
  
  <p>Expected result as follows</p>
  
  <pre><code>event_id   eventstartdate    eventenddate
        1      2013-09-27         2013-10-27 
        2      2013-10-18         2013-11-18
        3      2013-06-11         2013-06-13
        4      2013-02-05         2013-02-12
        5      2012-11-06         2012-11-23 
        6      2012-10-02         2012-10-20
  </code></pre>