Hi All,

Using MySQL 4.0.25

I am trying to show the count of specific records from one query using the following.

"SELECT area, COUNT(*) FROM table GROUP BY area ORDER BY area".

I can do this in a list using a loop with an example of results

area1(20)
area2(13)
area3(34)

but is it possible to retrieve the count of individual areas using the query above or do I have to write separate queries for each area. The aim is to have each area of a map show their number of records.