hidden items
Hey Ray
In this screenshot the brand Alcon actually only has 2 live products (2 are not live) but the total of 4 is showing in the breadcrumbs. The recordset I am using is
<?php
$ManufacturerBreadcrumbs = new WA_MySQLi_RS("ManufacturerBreadcrumbs",$DBConnection,0);
$ManufacturerBreadcrumbs->setQuery("SELECT ManufacturerName, Live, ManPermalink, (SELECT count(*) FROM products WHERE ProductManufacturerID = ManufacturerID) AS manCount FROM productmanufacturers WHERE Live = 1 ORDER BY ManufacturerName ASC");
$ManufacturerBreadcrumbs->execute();
?>
and in the same vein, if one has no live items such as this screenshot it is still visible. thi sis the recordset for that:
<?php
$TypeBreadcrumbs = new WA_MySQLi_RS("TypeBreadcrumbs",$DBConnection,0);
$TypeBreadcrumbs->setQuery("SELECT CategoryName, Live, CatPermalink, (SELECT count(*) FROM products WHERE ProductCategoryID = CategoryID) AS typeCount FROM productcategories WHERE Live = 1 ORDER BY CategoryOrder ASC");
$TypeBreadcrumbs->execute();
?>
Not sure what I am doing wrong for the hidden items to still be showing in the count?