How do I add code to the module to stop it displaying empty categories?

Thanks

Lee

Erik,
Thanks for the reply, I have unpublished the categories and they still appear. I belive this is because there is no check during the sql query to test wether the category is published. I need to add something along the lines of:

"AND #__{vm}_product.product_publish='Y' \n";

within, I think:

$database->setQuery("select count(*) from #__vm_product_category_xref where category_id = ".$row->category_child_id);

Thanks

Lee