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
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.