[SOLVED] List of unique entries and counting duplicates

[joshgarrod]

Hi, I am trying to create a list of all of the different types of makes that are listed in my database and how many of them, (similar to how eBay has down the left side) but I am getting the following warning:

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

 

I cannot figure it out, any ideas, here is my code:

 

<?php
$query = "select make, count(make) from classifieds where make in (select distinct make from classifieds) group by make";
			$result = mysql_query($query);

			while($row = mysql_fetch_assoc($query)){
    echo $row['make'].' ('.$row['count(make)'].')<br />';
}
?>

 

Thanks in advance

[btherl]

You are fetching from the $query instead of the $result.  Don't worry, I've done that a million times

[joshgarrod]

brilliant, I can never spot my little errors, thanks V much