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?

You have to add the WHERE into the nested select statement as well:

(SELECT count(*) FROM products WHERE ProductManufacturerID = ManufacturerID AND Live = 1) AS manCount

'fraid thats not made any difference

Let me see a copy of the page.

here you go

It looks correct... What happens when you test the query in phpMyAdmin?

i get the attached

Should it be ProductLive = 1?

You are of course, as always, correct!! lol

I forgot to change it for the new WHERE in the nested select statement....

Also, on the TypeBreadcrumbs, I used a show if to remove the empty entries <?php if (($TypeBreadcrumbs->getColumnVal("typeCount")) > 0) { ?><?php } ?>

Thanks for your help