Your second proposition is close to what I need, but my Grail would be to have the list of the authors (sorted alphabetically) each with its associated books published in a given collection. I guess that with some tweaking of the array of results I can get there but it's not very elegant. Thanks again.
On 28 fév, 23:16, lowpass <zijn.digi...@gmail.com> wrote: > Go 3 levels deep so the data is arranged by the particular Collection > you're after. > > $data = $this->Author->Book->Collection->find( > 'first', > array( > 'conditions' => array( > 'Collection.id' = $c_id > ), > 'contain' => array( > 'Book' => array( > 'Author' > ) > ) > ) > ); > > Because the Book model has the collection_id you really only need to > go 2 models deep. > > $data = $this->Author->Book->find( > 'all', > array( > 'conditions' => array( > 'Book.collection_id' = $c_id > ), > 'contain' => array( > 'Collection', > 'Author' > ) > ) > ); > > But then the data will be arranged badly. Collection, for instance, > will be repeated for each Book. -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php