I have developed a forum written in PHP with a mysql backend. The forum has a table, but I also have a table with members info, and another table that has a "friends" list. The friends list has the member and who they are friends with, like so:
[ID] - [Member] - [Friend]
On slashdot and other sites, they show for relationships of members. For instance, your friends might show up in a different color or something similar. Does anybody have any advice on whats the best way to accomplish this? I'm not sure how to setup or change my table structure and was just wondering if anybodys had any experience programming a similar system. Thanks for any help.