@Andras: Have you read the rest of the thread? Jeremy is trying to
show Daniel how to use containable so he can specifically say what
models and fields he wants to fetch during his find call. It's very
unhelpful you chiming in 25 messages into the thread telling him to
pull the model and ALL it's unnecessary related model data (a point
that was covered earlier in the thread).
@Daniel: Jeremy has given you all the correct information. The
following will pull the category matching $id and all it's matching
Posts and their Users (if you have your relationships set correctly.
$this->Category->find(
'first',
array(
'conditions' => array('Category.id' => $id),
'Contain' => array(
'Post' => array(
'User' => array(
'User.id',
'User.name'
)
)
)
)
)
If you're still having problems understanding this please go back to
the cookbook and follow what it tells you step by step, there is
nothing in this thread which is not covered there as this is basic
stuff:
http://book.cakephp.org/view/1323/Containable
HTH, Paul.
On Nov 4, 11:06 pm, Andras Kende <[email protected]> wrote:
> Daniel,
>
> The easiest way to do what you need is:
>
> <?php
> class CategoriesController extends AppController {
>
> public function index($id = null) {
> $posts = $this->Category->Post->find('all', array(
> 'conditions' => array('Category.id' => $id),
> ));
> // print_r($posts); to debug...
> $this->set(compact('posts'));
>
> }
> }
>
> This will just do a single query with 2 left joins..
> Just make sure all 3 models has the relationships setup correctly..
>
> Andras Kende
--
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
