Still trying to collect results!

I've posted a similar query before but had difficulty understanding the concept - can anyone lead me through this slowly?

I have a result set generated by the following code:

$sql2 = "SELECT * FROM table";
$conn = mysql_connect($db_host,$db_user,$db_pass);
$db = mysql_select_db($db_name,$conn);
$res2 = mysql_query($sql2);

while($myrow=mysql_fetch_array($res2)) {
print "$myrow[keyword], $myrow[sector], $myrow[location]<br>";
}

I get results like this:

, , Scotland
graphic design, , Scotland
graphic design, , Scotland
, Websites, Scotland
, , Scotland

How can I alter my code to show:

, , Scotland - 2
graphic design, , Scotland - 2
, Websites - 1

I'm fairly new to this game but I gotta get this done by end of today to meet a deadline! Please help :]

SELECT DISTINCT keyword,sector,location,COUNT(keyword) FROM APO_ABHOL GROUP BY keyword,sector,location

try this query...it mite work

Nah - not right...

This does seem to collect results, but 'count' isn't accurate.

I don't think its counting identicle GROUPS of variables - it seems to be collecting individual fields... ...can't really figure it out.

I think I need to loop through my results and create another array with count values but I'm not sure how to :[

Any ideas?

Dunno i tried the same query here in my db
and it worked fine....

Why do u need loops when u can get the entire result in just 1 query?