How do I show number of..

[fried-chicken]

hi, got script running

at www.officelets.net

i want it to show the number listing in that area and then sub listing.

example:

England (10)
East Anglia (3)
East Midlands
Greater London
North East (3)
North West
South East
South West (4)
West Midlands
Yorkshire and Humberside
Northern Ireland (7)
East (7)
North
South
West
Scotland (32)
Central Scotland
Edinburgh (11)
Glasgow (21)
Highlands and Islands
Lowlands
Wales (7)
Mid Wales
North Wales (3)
South Wales (4)


any one have idea?

cheers

 

[mch]

Give me the current script and I'll revise it for ya.

 

[monaco]

Put another field in the database that defines their grouping, then modify the query to return a count grouped by that grouping.