Counting X items in each category..?!

[griffith]

I have to tables, one for the category-names and one for the info about each "thing" in each category. In the "info" table, there is a foreign key (hope it is the right "name"??) to the category table. So each "thing" in the info table, has a category id so that I can see which category it belongs to.

My problem is that I want to output the categories and also want to show how many "things" there are stored in each category. Not sure how to to this.

Example: category1 (12 items)

category2 (31 items) and so one..

[totof06]

Try:

SELECT CategoryName ,
"(" + COUNT(ItemID) + ")"
FROM Category,
Items
WHERE Category.ID = Items.ID
GROUP BY CategoryName

Christophe.
www.realscale.com

[griffith]

hmm.. didn't get that to work.. and can you do like this:

"(" + COUNT(ItemID) + ")"

??

[totof06]

"(" + COUNT(ItemID) + ")" works on MSSQL... It was to obtain a result like:

Category1(12)

But you can only keep "COUNT(ItemID)" and format your result set in PHP...

Christophe.
www.realscale.com

[griffith]

Got it work.. but not exactly the way you said.. because I didn't get it working with the "(" +.....+ ")", but worked fine without.. thanks 🙂