The group by is throwing it off. When you use a group and an order together you typically do not get the expected result. In order to get the desired results you might need to do an inner select. I don't remember the correct way to do it off the top of my head though to get what you are looking for. I do know though that the group by clause is what is causing your issues.
On Thu, Oct 18, 2012 at 4:47 AM, anwar korti <[email protected]> wrote: > Hello In a Message controller I try to display the latest message of each > user (sender) for a connected one (receiver) I try this but I still find > the first entry. Thank you for your help > > Messages table: > > > - id > - user_id -> Sender > - receiver_id -> receiver > - content > - created -> datetime > - statut -> read or not > > $this->set('messages', $this->Message->find('all', > > array( > 'conditions' => array('Message.receiver_id'=>$user), > 'order' => array('Message.created desc'), > 'group'=>'Message.user_id'))); > > -- > Like Us on FaceBook https://www.facebook.com/CakePHP > Find us on Twitter http://twitter.com/CakePHP > > --- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en. > > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
