title: Count of rows month wise for a given year
body: <p>I want to select Registration per month.</p>
  
  <pre><code>&lt;?php
  include 'member_entry/sdg_connect.php';
  
  $sql="select member_id from sdg_members where member_joindate BETWEEN  DATE('2015-02-30') AND DATE( '2016-12-31')";
  
  if ($result=mysqli_query($conn,$sql))
    {
        $rowcount=mysqli_num_rows($result);
        echo $rowcount;
  
        mysqli_free_result($result);
    }
  
    mysqli_close($conn);
   ?&gt;
  </code></pre>