Setting up a self-referential many-to-many relationship

2007-03-06 Thread thelorax
Hello, I just started playing with Cake yesterday and am trying to set up a self referential many to many relationship using an example of users/ friends that is common to most social networks. To set up the DB I created two tables; users with id and username, and friends with user_id and

Setting up a self-referential many-to-many relationship

2007-03-06 Thread thelorax
Hello, I just started playing with Cake yesterday and am trying to set up a self referential many to many relationship using an example of users/ friends that is common to most social networks. To set up the DB I created two tables; users with id and username, and friends with user_id and