Posted by Ac1d^ on 04/10/06 16:51

My fault,


at the end of select you need to add "group by Category.CategoryID"
and you will get what you need.

• Next in forum: Retrieving fields name from mysql
• Prev in forum: Re: Count Number of Items in each Category
• Thread view: Re: Count Number of Items in each Category

[Reply to this message]