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