[RESOLVED] SELECT DISTINCT query help

[Paul_Ferrie]

Hi guys i need some help with a query.

I have a database of user data.
I am trying to get the distinct locations from the database and how many occurrences of each location.

I got as far as

 SELECT DISTINCT gbLocate
FROM `idGb`
LIMIT 0 , 30 

This only returns the distinct locations and not how many occurrences of it there is.

thanks for any help

[wilku]

You should use GROUP BY.

SELECT gbLocate, COUNT(gbLocate) 
FROM `idGb` 
GROUP BY gbLocate
LIMIT 0 , 30 

[Paul_Ferrie]

Cheers bud