Thanks for the instruction, it now works. On 26 tra, 23:22, cricket <[email protected]> wrote: > 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
