Hi,

I have the following issue where I am a bit stuck. I have 3 tables

maincategories
- id
- maincategory

subcategories
- id
- subcategory
- maincategory_id

recipes_subcategories
- id
- recipe_id
- subcategory_id

The Maincategories are shown as a Navigation. I created an element for
this. Everything works fine. The next step I would like to achieve is
to count the amount of recipes for each maincategory.

Right now I use this code in my maincategories_controller:

if(isset($this->params['requested'])) {
     return $this->Maincategory->find('all', array('order'=>array
('Maincategory'=>'asc'), 'recursive' => 0));

How do I get the amount of recipes shown with my above Database
struktur? Could someone give me a hint? I am pretty stuck with it and
can't think of a solution. Thank you very much in advance.

Regards Luke

You'd probably want to take a look at CounterCache in the book; this
would require a modification (an additional field) to your
maincategories table, and a little bit of code, but would ultimately
be quicker than a separate query.  Another suggestion would be to look
at find('count') if you don't want to modify your tables, and to learn
how caching works (and use it).

On Jul 3, 11:25 am, Luke <eik...@hotmail.com> wrote:

I am new to Cake PHP but I can give you the sql to get the count

select count(*), maincategory
from maincategories mc, subcategories sc, recipes_subcategories rsc
where mc.id = sc.maincategory_id
AND sc.id = rsc.subcategory_id
AND mc.id = $this->params["category_id"]
group by mc.id

Thanks,
Ramu.

On Jul 3, 8:25 pm, Luke <eik...@hotmail.com> wrote:

Hi,

I just had a look at the CounterCache, but seem to struggle on the
implementation. I added another field to my maincategories
table:
recipes_count

I suppose I have to add now 'counterCache'=>true to my Maincategory
model, my relationships are currently looking like this

-----------------------------
Maincategory model
-----------------------------
var $hasMany = array('Subcategory' )

-----------------------------
Recipe Model:
-----------------------------
var $belongsTo = array(
                'User' => array(

var $hasAndBelongsToMany = array(
                'Subcategory'=> array(

-----------------------------
Subcategory Model:
-----------------------------
var $belongsTo = array('Maincategory')

var $hasAndBelongsToMany = array(
                'Recipe' => array(

into which Model I have to add the 'counterCache'=>true ?? I have
tried it with the HABTM so into recipe and subcategory model and than
used this:
http://bakery.cakephp.org/articles/view/counter-cache-behavior-for-ha...

Unfortunately this did not work. Of course I would like to have the
counter in the maincategory table, but is this so easy to reach if I
actualy don't save anything into this table when I add a new recipe?

How would counterCache be activated? Do I have to call it up in the
controller aswell?

Any advice will be great.

Luke