My $.02: use finderQuery. That's only a hunch though, and not based on practical experience.
On Sun, May 11, 2008 at 3:44 AM, woldhekkie <[EMAIL PROTECTED]> wrote: > > Users want to plan routes to ride together on a a motor bike. > tables: > users (id, name,phone,email) > routes (id,date,time,startplace,info,user_id) (user_id is user > who planned the route) > routes_users (id,route_id,user_id) (extra table for which user goes > on which route with habtm) > > Having HABTM working, i see the following route view: > > Routes: > Date Time Startplace > info Owner Totalusers > 10-10-2009 09:00 Amsterdam Nice route round Amsterdam > woldhekkie ???????? > > > How to get the count() of Totalusers per route. > Do i have to do it from the controller (conditions) or from the model > (finderquery,conditions) or best to do it in PHP array ? > > Thanks in advance > > > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---