I wrote a small example on this a while back, can be found here :- http://wiltonsoftware.com/posts/view/custom-group-by-pagination-and-a-calculated-field
On Wed, Mar 4, 2009 at 6:22 PM, Rimoe <meiyo...@gmail.com> wrote: > hi, > I have write a > var $paginate = array( > 'limit' => 50, > 'fields' => array('acc_id', 'count(*) as countnum'), > 'order' => array('countnum ' => 'desc'), > 'group' => array('acc_id') > ); > the paginate can't get the paginate's count, > > can't pagination use the group by ? > or how to use the group by in paginate. > > Thanks > rimoe > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---