Thanks John,
I went ahead with that, but am using a separate table called favorites to
store the association. I'm using:
ThingFunction model:
var $belongsTo = array(
'User' => array(
'className' => 'User',
),
);
var $hasAndBelongsToMany = array(
'User' => array(
'joinTable' => 'favorites',
'unique' => true,
)
);
User model:
var $hasMany = array(
'ThingFunction' => array(
'className' => 'ThingFunction',
'conditions' => 'ThingFunction.is_inappropriate = 0'
)
);
var $hasAndBelongsToMany = array(
'ThingFunction' => array (
'joinTable' => 'favorites',
'unique' => true,
'conditions' => 'ThingFunction.is_inappropriate = 0'
)
);
In my Users controller I'm trying to fetch a user's favorites using this:
$favorites = $this->User->Favorite->find('all', array(
'conditions' => array('Favorite.user_id' => $id)
)
);
When I look at the debug info, I get the following results:
Array
(
[0] => Array
(
[Favorite] => Array
(
[id] => 1
[user_id] => 1
[thing_function_id] => 56
)
)
)
The data above is correct, but I would also like to get the ThingFunction
title and description (each ThingFunction has fileds thing_function_title
and thing_function_description). How would I get the ThingFunction details?
Also, I have recursive set to -1 in my AppController.
Thanks much!
Best Regards,
Tamim
On Fri, Oct 16, 2009 at 11:44 AM, John Andersen <[email protected]>wrote:
>
> You have two associations between the User and the ThingFunction
> model:
> - the owner association is - User hasMany ThingFunction -
> ThingFunction belongsTo User.
> - the favorites association is - User hasAndBelongsToMany
> ThingFunction and vice verse.
>
> Hope this helps you on the way :)
> Enjoy,
> John
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
