Re: habtm count() query

2008-05-12 Thread b logica

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
>  infoOwner   Totalusers
>  10-10-200909:00Amsterdam 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
-~--~~~~--~~--~--~---



habtm count() query

2008-05-11 Thread woldhekkie

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
infoOwner   Totalusers
10-10-200909:00Amsterdam 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
-~--~~~~--~~--~--~---