title: Getting rows between date range in mysql
body: <p>I am having a serious issue I can not figure out. I am trying to return rows from MySQL database that have a Start date between two given dates and an End date as well. Here is my php code to query the database:</p>
  
  <pre><code>$getRooms = mysql_query("
      SELECT * 
      FROM Tarifas 
      WHERE Start BETWEEN '2013-01-10' AND '2013-01-13' 
      AND   End   BETWEEN '2013-01-10' AND '2013-01-13'
  ");
  </code></pre>
  
  <p>Start and End are set up as DATE fields</p>
  
  <p>my database is set up as follows:</p>
  
  <pre><code>ID | RoomId | Start      | End
  --------------------------------------
  4  | 34562  | 2013-01-09 | 2013-10-23
  </code></pre>
  
  <p>If anyone can help me figure out why this is not working, it would be greatly appreciated!!</p>