title: Search according to selected date range
body: <p>Hello wonderful programmers.</p>
  <p>I created the following code :</p>
  <pre><code>if(isset($_GET['from_date']) &amp;&amp; isset($_GET['to_date']))
   {
   $from_date = $_GET['from_date'];
   $to_date = $_GET['to_date'];
  
   $query = &quot;SELECT * FROM student WHERE issuance_date BETWEEN '$from_date' AND '$to_date' &quot;;
   $query_run = mysqli_query($conn, $query);
  
   if(mysqli_num_rows($query_run) &gt; 0)
   {
       foreach($query_run as $row)
       {
           ?&gt;
  </code></pre>
  <p>The thing is, I want to display all members registered during the selected period, but the problem is that it just displays the last two registered entries and neglects the first one. To put it differently, yesterday for example three members have registered, when I select the date to display the members it only displays the last two regestered ones. The same thing happens with any different selected date range.</p>
  <p>NB: <strong>$date = date('Y-m-d H:i:s');</strong> This is how the date is automatically inserted into the database when I insert a new entry.</p>
  <p>Here is an example of the registered members:
  <a href="https://i.stack.imgur.com/s0rOX.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>and here is what happens when I select a date:
  <a href="https://i.stack.imgur.com/pqp2m.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>thank you</p>