Re: Count Number of Items in each Category
Available news archives: comp.lang.tcl - comp.lang.python - comp.security.firewalls - sci.crypt - comp.lang.php - comp.lang.javascript
Google
 
Web news.hping.org


comp.lang.php archive

Re: Count Number of Items in each Category

From: Ac1d^ <adam82s@gmail.com>
Date: Mon Apr 10 2006 - 09:31:56 CEST

Select
Category.CategoryID,
Category.Category,
Category.Sorting,
Count(Listings.CategoryID)
From
Category LEFT JOIN Listings on(Listings.CategoryID=category.CategoryID)

Order By
Category.Sorting Desc
Received on Mon May 1 02:52:25 2006