Results 1 to 7 of 7
Jan 15, 2006, 13:00 #1
- Join Date
- Oct 2001
- Helston, Cornwall, England
- 0 Post(s)
- 0 Thread(s)
Retrieving individual COUNT records
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.