Re: How to get related username in view?

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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php