Hey, ah ok I think we both mean the same thing, but I forgot that the relation is not only by one side, but by two sides.
So a simple example would look like this: Table friends: id user1_id user2_id 1 1 2 2 5 2 3 3 1 4 4 1 5 2 4 This would mean: User 1 is a friend of: 2, 3 and 4 User 2 is a friend of: 1, 4 and 5 User 3 is a friend of: 1 User 4 is a friend of: 1 and 2 User 5 is a friend of: 2 Is that correct? I think it is...? On 27 Aug., 18:33, Miles J <[email protected]> wrote: > Not necessarily. If you are doing a friend system, the table would > look like so: > > friends: id, user1_id, user2_id > > And 1 row would be for both user1 and user2, instead of adding 2 rows > for each user. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
