Thx adam, working perfectly
Regards,
On May 3, 3:43 am, Adam Royle <[EMAIL PROTECTED]> wrote:
> As long as you have var $belongsTo = array('Author'); in your Comment
> model, just set recursive to a higher value.
>
> $this->Post->recursive = 2;
> $posts = $this->Post->findAll();
>
> Cheers,
> Adam
>
> On May 3, 3:40 am, deeps <[EMAIL PROTECTED]> wrote:
>
> > Ok, i m trying cakephp for one of my application, till now no errors
> > are there & cakephp is making life easy....
>
> > but now i am stuck in one simple problem
>
> > I am having these tables in database
>
> > Post
> > -id (PK)
> > -title
> > -description
>
> > Comment
> > -id (PK)
> > -comment
> > -post_id (FK)
> > -author_id (FK)
>
> > Author
> > -id (PK)
> > -name
> > -email
> > -website
>
> > Now Post will have many comments & each comment will have One author
>
> > Now in post if i write
> > <?php
> > var $name = 'Post';
> > var $hasMany = array('Comment' => array('className' => 'Comment',
> > 'conditions' => '',
> > 'order' => '',
> > 'limit' => '',
> > 'foreignKey' =>
> > 'post_id',
> > 'dependent' =>
> > true,
> > 'exclusive' =>
> > false,
> > 'finderQuery' => '',
> > 'fields' => '',
> > 'offset' => '',
> > 'counterQuery' =>
> > ''));
> > ?>
>
> > i will get
>
> > Array ( [0] => Array ( [Post] => Array ( [id] => 1 [title] => xyz
> > [description] => xyz ) [Comment] => Array ( [id] => 1 [comment] => xyz
> > [post_id] => 1 [author_id] => 1 )
>
> > What i want is instead of having author id in this particular result,
> > i want to show up author name with built in functionality of cakephp
> > or any shortcut method of cake instead of writing any custom query.??
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
