Posted by Jerry Stuckle on 04/10/06 07:13

Barkster wrote:
> I'm trying to list my categories and how many items are in each
> category. I'm not much on sub queries. How can I combine these two
> items. I'd like to display the category and the corresponding number of
> items in each
>
> Cats:
> Select
> Category.CategoryID,
> Category.Category,
> Category.Sorting
> From
> Category
> Order By
> Category.Sorting Desc
>
> Items:
> Select Count(Listings.CategoryID)
> From
> Listings
> Group By
> Listings.CategoryID
>
> I've tried the following but can't get it to work:
>
> Select
> Category.CategoryID,
> Category.Category,
> Category.Sorting,
> (Select Count(Listings.CategoryID)
> From
> Listings WHERE Listings.CategoryID = Category.CategoryID) AS cnt
> From
> Category
> Order By
> Category.Sorting Desc
>


It depends on your database - both which database and what version you're using.

Since this isn't a PHP question, try asking in a newsgroup for your database.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: Mysql table rows delete HELP
• Prev in forum: Re: PHP5 Object and Class Errors
• Thread view: Re: Count Number of Items in each Category

[Reply to this message]