Hiding empty categories
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Hiding empty categories
Add counterCache field to categories table and then use that field in
find('list') conditions.
http://book.cakephp.org/1.3/en/view/1033/counterCache-Cache-your-count
--
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Hiding empty categories
On 3 Jun 2012, at 18:30, stork wrote:
Add counterCache field to categories table and then use that field in
find('list') conditions.
http://book.cakephp.org/1.3/en/view/1033/counterCache-Cache-your-count
Very quick and neat, thanks for that.
I added the product_count field to my product_categories table. Then added
'counterCache' = true to my products model and...
'conditions' = array('ProductCategory.product_count ' = 0)
…to my products_controller find
Up and running.
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
