title: Multiple counts in one query
body: <p>This query doesn't work. Can someone help me please?</p>
  
  <pre><code>$query = "SELECT 
      COUNT(WHERE Name='george') AS george_total,
      COUNT(WHERE Name='michael') AS michael_total,
      COUNT(WHERE Name='mike') AS mike_total 
  FROM users WHERE Banned IS NOT '1' AND Active='yes' AND Logins&gt;1 AND Registered_to_forum='1'";
  
  $row=mysql_fetch_array($result);
  echo "
      We found $row['george_total'] people with the name 'George' in our database,
      $row['michael_total'] with the name Michael
      and $row['mike_total'] with the name Mike.
  ";
  </code></pre>