title: Select data between two dates?
body: <p>I'm using a database to store logs, with a column "date" which holds the date it was inserted. The format of the date is "MM/DD/YY". Please can anyone suggest how I would SELECT data in between two certain dates. For example, I tried this:  </p>
  
  <pre><code>$from_date = "01/01/12";
  $to_date = "02/11/12";
  
  $result = mysql_query("SELECT * FROM logs WHERE date &gt;= " . $from_date . " AND date &lt;= " . $to_date . " ORDER by id DESC");
  
  while($row = mysql_fetch_array($result)) {
  // display results here
  }
  </code></pre>
  
  <p>But I guess this doesn't work because the dates aren't numbers. Thanks for the help! :)</p>