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