title: MySQL Count Where Clause Issue
body: <p>I have a PHP form that has 3 drop-downs which enables the user to select parameters to be passed to a MySQL select statement. I want to return the total number of records dependant on the criteria selected.</p>
  
  <p>The problem I have is that the result returns several totals instead of a grand total.</p>
  
  <blockquote>
    <p>SELECT distinct count(membership_type) as total FROM members_main
    where membership_status like '%' and membership_type like '%' and
    200_member like '%' group by membership_type</p>
  </blockquote>
  
  <p>Can anyone help?</p>
  
  <p>Thanks,</p>
  
  <p>John</p>