fetching related models data.

Hi All,

I am using a model named 'Questions' It has relationships hasMany and belongsTo with few other models. Now I want to fetch data in controller such that i get all associated data for particular record in questions table.

For eg: - If I input a question_id = 1. I should get all the related data from other related models where question_id = 1 .

i have tried this.

$this->Question->find('all',array('condition'=>array('Question.question_id'=>1)));

$this->Question->User->find('all',array('condition'=>array('Question.question_id'=>1))); 

approximate structure of query i am expecting should be

select * from Questions,Users where Question.question_id=1 and Question.user_id=User.user_id;

--
Thank you,

Kiran.

--
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