Customizing ProductCart - Only brands with active products..

Print Page | Close Window

Only brands with active products..

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=4432
Printed Date: 23-November-2024 at 7:13am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Only brands with active products..

Posted By: p00pstar
Subject: Only brands with active products..
Date 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