I have a relationship that works very well. But putting in a condition gives me a headache.
I have the following: Users -HABTM- Groups -HABTM- Services So depending to which groups a user belongs he/she gets rewarded with some services. A Service->findAll() returns everything I want (all services of all users), but now I want to restrict the results of findAll() with only the services the user (which is logged in and the id is stored in the session) has a right to. I tried filling in the $conditions array with things like array( 'users_groups.user_id' => the_user_id_in_the_session ) and such but it keeps complaining about not having the said column, which is correct because it does a SELECT of the services table. I have a headache. Where do I start solving this. I could eventually dig into the complete array in the view and only show the said services but that does not seem to be the right MVC way... Can somebody give me a pointer? TIA Paul --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
