[SOLVED] SELECT DISTINCT and COUNT

[scarhand]

I am trying to output distinct band names, but count the amount of rows they take up in the database

 

this is not working:

 

  $sql = mysql_query("SELECT DISTINCT(band), COUNT(band) as count FROM tabs WHERE band LIKE '$letter%' LIMIT 100");
  
  while ($row = mysql_fetch_array($sql))
  {
    $band = $row["band"];
    $count = $row["count"];
    
    echo "$band - $count<br>";
  }

 

any help is appreciated

[fenway]

Please post your solution.

[scarhand]

I figured this out:

 

<?php
mysql_query("SELECT DISTINCT(band), COUNT(band) AS count FROM tabs WHERE band REGEXP '^$letter' GROUP BY band");
?>