Only brands with active products..

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi everyone,

I figured someone would also benefit from this. 
It changes viewbrands.asp to show only the brands that actually have any products.

You should change the query (around line 55,56) to this :

query="SELECT distinct pcBrands_Order, brands.idbrand, BrandName, BrandLogo, pcBrands_Description, pcBrands_SDescription, pcBrands_SubBrandsView, pcBrands_ProductsView, pcBrands_Active, pcBrands_Parent, pcBrands_MetaTitle, pcBrands_MetaDesc, pcBrands_MetaKeywords, pcBrands_BrandLogoLg FROM Brands, products WHERE pcBrands_Active=1 and brands.idbrand=products.idbrand AND products.active=-1"&query1&" ORDER BY pcBrands_Order, BrandName ASC;"

Have fun !

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
p00pstar Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-March-2007 Location: Romania Status: Offline Points: 0	Post Options Post Reply Quote p00pstar Report Post Thanks(0) Quote Reply Topic: Only brands with active products.. Posted: 19-April-2011 at 8:55am
	Hi everyone, I figured someone would also benefit from this. It changes viewbrands.asp to show only the brands that actually have any products. You should change the query (around line 55,56) to this : query="SELECT distinct pcBrands_Order, brands.idbrand, BrandName, BrandLogo, pcBrands_Description, pcBrands_SDescription, pcBrands_SubBrandsView, pcBrands_ProductsView, pcBrands_Active, pcBrands_Parent, pcBrands_MetaTitle, pcBrands_MetaDesc, pcBrands_MetaKeywords, pcBrands_BrandLogoLg FROM Brands, products WHERE pcBrands_Active=1 and brands.idbrand=products.idbrand AND products.active=-1"&query1&" ORDER BY pcBrands_Order, BrandName ASC;" Have fun !
	www.dotdesignmedia.ro // web application development