title: Selecting records between two dates using PHP from MySql database
body: <p>In my project , I am generating and storing the Bill (invoice).
  The date of Bill is coming to the textbox from the javascript date picker(small pop-up calender) before saving.
  <strong>The format of the date is : DD-MON-YYYY (18-JUN-2013).</strong></p>
  
  <p>I am using '<strong>Text</strong>' data type for storing dates in MySql table.</p>
  
  <p>I have done selecting of records(Previous Bills) from the table by given single date like. . .</p>
  
  <blockquote>
    <p>$result = mysql_query("SELECT * FROM outward WHERE date='".$date."' ORDER BY billNo");</p>
  </blockquote>
  
  <p><strong>Now, what i want to do is:</strong>
  To select records (Bills) between two dates.....</p>
  
  <blockquote>
    <p><strong>My exact Question is:</strong>
    Is it possible to query mysql database with this settings or I have to make some changes to select records between 2 dates efficiently ?
    How can i achieve this ?</p>
    
    <p><strong>P.s.</strong> - Is it effective to use <br>
    <strong>1.</strong> "SELECT * FROM outward WHERE date BETWEEN '" . $from_date . "' AND  '" . $to_date . "' ORDER by id DESC" <br>
    Or<br>
    <strong>2.</strong> SELECT * FROM outward WHERE date > "15-JUN-2013" and date &lt; "18-JUN-2013"</p>
  </blockquote>