in case you don't find the "good" way ti do it.... i suggest you to
create a custom model method using $this->query('your custom query')On Feb 6, 7:57 pm, "[email protected]" <[email protected]> wrote: > Hello! > > Im been at this for hours and hanging in the IRC channel, without > getting the final solution. > I want to share events between users... > > **I have these relations: > User hasmany Event > Event HABTM User > > **I have these tables > [events] > -id > -user_id > -title > > [users] > -id > -email > -and some other columns thats not interesting > > [events_users] > -id > -event_id > -user_id > -group_id (not used at the moment) > > When i perform > $this->set('events', $this->Event->find('all')); > > I get this result: > (this is $events) > > Array ( > [0] => Array ( [Event] => Array ( [id] => 9 [user_id] => 12 [title] => > asdadggggg ) [User] => Array ( ) ) > [1] => Array ( [Event] => Array ( [id] => 12 [user_id] => 28 [title] > => Coooolllmaann ) [User] => Array ( ) ) > [2] => Array ( [Event] => Array ( [id] => 23 [user_id] => 13 [title] > => hehe, NOT SO FUNNY! ) > [User] => Array ( [0] => Array ( [id] => 12 [email] => aberg > [password] => 5b1fb8132b0dee40ed8aec0e0049fb005f612e55 [fname] => > [ename] => [status] => 0 > [EventsUser] => Array ( [id] => 1 [event_id] => 23 [user_id] => 12 > [group_id] => 0 ) ) ) ) > [3] => Array ( [Event] => Array ( [id] => 26 [user_id] => 12 [title] > => OBOYOYOYOYOY12 ) [User] => Array ( ) ) ) 1 > > ----- > What i want to do with this array is that i want to collect those > Events that has user_id = 12. Which normally is 'id':9 and 26. Though > id 23 is shared to user_id 12. Therefore i want to collect it aswell! > > I dont know how to do this and have been searching for hours... > > Any help is greatly appreciated and i hope this can help others that > have the same problem. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
