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 -~----------~----~----~----~------~----~------~--~---
