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
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
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
