I'm on CakePHP 1.3

On my products/index.ctp view I show a menu of categories and list all the 
products from the selected category. However I don't want to show categories 
where there are no products.

Currently the data comes from my products_controller.php

        function index($id = 1) {
                $this->Product->recursive = 0;
                $this->set('currentcategory', $id);
                $this->set('products', $this->Product->find('all', 
array('conditions' => array('ProductCategory.id' => $id))));
                $this->set('categories', 
$this->Product->ProductCategory->find('list', array('fields' => 
array('ProductCategory.id', 'ProductCategory.name'))));
        }

What is the best way to only find those categories with products?

Cheers

Paul

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to