On Tue, Apr 26, 2011 at 4:35 PM, Salines <[email protected]> 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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
