Hiding empty categories

2012-06-03 Thread Paul Willis
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) {

Re: Hiding empty categories

2012-06-03 Thread stork
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

Re: Hiding empty categories

2012-06-03 Thread Paul Willis
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