Thanks a lot ! Also I just wanted to post one other way to do this because I googled and just found out.
before your query just post smth like this.. $this->Custommer->hasMany['Payment']['order'] = 'id DESC'; $this->Custommer->hasMany['Payment']['limit'] = 2; you can also place conditions there. Thanx Jeremy ! All the best ! Milos On Feb 23, 4:27 pm, jeremyharris <[email protected]> wrote: > You can do this in a single find() call, using containable. (It will still > create many mysql queries because that's just the way it needs to be done, > however it will filter all the data for you). > > Something like: > > $this-> Customer ->find('all', array( > 'conditions' => array( > 'Customer.id' => 1 > ), > 'contain' => array( > 'Invoice' => array( > 'order' => 'Invoice.created DESC', > 'limit' => 2 > ), > 'Credit' => array( > 'conditions' => array('Credit.active' => true) > ) > ) > )); > > This should fetch the customer info and include that customer's last 2 > invoices and all active credits. -- 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
