Re: read(null,$id) or findById($id) and limit data in associated model

Thanks for the instruction, it now works.

On 26 tra, 23:22, cricket <zijn.digi...@gmail.com> wrote:
> On Tue, Apr 26, 2011 at 4:35 PM, Salines <nikola.parad...@gmail.com> wrote:
> > Sorry my English is not good.
>
> > when I call exp,www.example.com/brands/view/2
>
> > Show some information about the brand and the last 9 related products
> > added to the database, which are active 1 (online status).
>
> > The brand has many products, maybe 100, but I need only last 9.
>
> The default 'recursive' option should cause Cake to grab the
> associated Products if your model associations are set up correctly.
>
> That said, to include just the 9 most recent Products, you should
> consider using ContainableBehavior.
>
> $this->set(
>         'data', // not $this->data
>         $this->Brand->fetchWithProducts($id)
> );
>
> Brand model:
>
> public function fetchWithProducts($id)
> {
>         return $this->find(
>                 'first',
>                 array(
>                         'conditions' => array(
>                                 'Brand.id' => $id
>                         ),
>                         'contain' => array(
>                                 'Product' => array(
>                                         'order' => array(
>                                                 'Product.created' => 'DESC'
>                                         ),
>                                         'limit' => 9
>                                 )
>                         )
>                 )
>         );
>
> }
>
> view:
> debug($data);

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