Ok I have searched before asking, all I found was several questions asking what I am but 0 answers so maybe someone who knows will see this or I will make it a more clear question.I have a social network similar to myspace/facebook. In my code you are either a person's friend or not a friend, so I show all actions from people you are friends with (in this post I will refer to actions as bulletin posts alone to make it easier to visualize. So you every time a person post a bulletin it will show up to any person who is there friend.So in mysql you would get a persons friend list by doing something like this, \[code\]SELECT user_id FROM friends WHERE friend_id = 1 (user ID)\[/code\]I want to know how a site like facebook and some others would show all bulletin post from your friends and from your friends' friends? If anyone has an idea please show some code like what kind of mysql query?
Friend of a friend in PHP/MySQL?
- Thread starter SypeCoozy
- Start date