Why don't you use a where instead of a group function? On 7/22/06, Skip Evans <skip@xxxxxxxxxxxxxxxxx> wrote:
Hey all, I have a table like this: boroughID Area ========= ==== 1 Chelsea 1 East Village 1 West Village 1 So Ho 2 Prospect Park 2 Brooklyn Heights 3 Prospect Heights What I want to know is which boroughID has the most area's assocated with it, and how many. So I tried this: SELECT max(count(*)) FROM `bsp_area` GROUP BY boroughID ...and got an "Invalid use of group function" error. Anyone think of another way to do this in a single SQL statement, or some other simple method? -- Skip Evans Big Sky Penguin, LLC 61 W Broadway Butte, Montana 59701 406-782-2240 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- Dave W
