Re: Is Cake capable of building up a small or medium social network?

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 <mileswjohn...@gmail.com> 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---