title: mysql query for filtering specific rows by date condition in php?
body: <p>I have a table '<strong><em>meetings</em></strong>' which has following fields</p>
  
  <pre><code>id   recurring_start_date  recurring_end_date (Both are date fields)
  1.    2012-07-22             2012-07-25
  2.    2012-07-27             2012-08-05
  3.    2012-07-26             2012-08-26
  4.    2012-07-23             2012-10-23
  5.    2012-08-24             2012-11-24
  6.    2012-09-12             2012-10-19
  7.    2012-07-28             2012-07-29
  </code></pre>
  
  <p>I want to filter those rows by sql query which contain '<strong>2012-07-28</strong>' date between <strong>start-end recurring dates</strong> range and including start n end recurring date.<br><br>
  We know result will be 2nd, 3rd, 4th, 7th rows.<br>
  But how do i run this query in php.<br></p>
  
  <p>I tried this, but its not working.<br></p>
  
  <pre><code>$sql = "
      SELECT * 
      FROM 
          `meetingss` 
      WHERE 
          `recurring_st_date` &gt;= \'2012-07-28\' 
          AND `recurring_ed_date` &lt;= \'2012-07-28\' 
      ";
  </code></pre>
  
  <p>May be am going wrong , may be supplied date condition wrong.<br>
  Any good suggestion my mates to do this. Thanks...</p>