title: Check if the current date is between two dates + mysql select query
body: <p>I have the following table : </p>
  
  <pre><code>id     dateStart     dateEnd      active
  1      2012-11-12    2012-12-31   0
  2      2012-11-12    2012-12-31   0
  </code></pre>
  
  <p>I want to check if today's date is in between <code>dateStart</code> and <code>dateEnd</code>.</p>
  
  <p>The following is my query for this : </p>
  
  <pre><code>$todaysDate="2012-26-11";
  $db = Zend_Registry::get("db");
  $result = $db-&gt;fetchAll("SELECT * FROM `table` WHERE active=0 AND {$todaysDate} between dateStart and dateEnd");
  return $result;
  </code></pre>
  
  <p>But so far it's not working as it returns zero rows.</p>