Posted by Barkster on 04/10/06 15:53

I was hoping it was that simple but when I run that I get an error:
Mixing of a GROUP colums (min(), max(), Count()) with no GROUP columns
is illegal if there is no GROUP BY clause

I'm trying do display something like this, where number of items in
each category is in parenthesis.

Category1(25)
Category2(57)
Category3(240)

• Next in forum: Re: Chmod
• Prev in forum: Re: Macros in php
• Thread view: Re: Count Number of Items in each Category

[Reply to this message]