I have three models
Authors
Books (hasandbelongstomany category)
Category
They are properly configured for $hasAndBelongsToMany (books/category)
relationship.
I need to get all books by an author in a certain category (5 in this
example)
Obviously the category id is not in the authors table so I am trying to
figure out how to reference the category id. I have tried below to no
avail.
$this->Category->Author->find('all',
array('conditions'=>array('Category.id'=>'5', 'Author.id'=>'2')));
or
$this->Author->find('all', array('conditions'=>array('Category.id'=>'5',
'Author.id'=>'2')));
This is the first time I have done a HABTM query. (searched manual and and
a couple cake books - no help)
Thanks!
--
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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
