pointing one user to many?

[deep]

Hello,

I got a little problem here. Im building a db where one user can have multiple friends.

My db looks like this:

TABLE user_friends {
friends_id int(10) NOT NULL auto_increment....
user_id int(10)....
friends_id int(10)...
}

Now the plan is to add the user selecting a friend into "user_id" and to add his new friends id number into "friends_id". That way I will know who the users friend is BUT im not sure how to build the db and the php code for adding multiple friends to one user....??

Can I use this method to add multiple friends to one user or is there a better way???

If this method is good, then i would be very happy if you could show me a php code exampel for extracting all the friends. Im not sure how to do that when I got this data in the db:

user_id......friends_id
1................2
1................5
2................3
1................7

Thanks!

[nemonoman]

Your basic design sounds OK, but I think you only need two basic columns in your user_friends table:

user_friends

user_id
friend_id

user 1 establishes as friends users 10,11, 12
user 10 establishes as friends users 1,2, 3

user_id/friends_id
1/10
1/11
1/12
10/1
10/2
10/3

You can find all the user's friends:
SELECT friend_id FROM user_friends WHERE user_id=1

You can find all the people who have designated this user as a friend:
SELECT user_id FROM user_friends WHERE friend_id=1

[deep]

Hello!

Using:
SELECT friend_id FROM user_friends WHERE user_id=1

will only get me the first friend in the list... I have tried using foreash after putting the result in an array but no luck... 😕

Thanks!!

[nemonoman]

$result=mysql_query("SELECT friend_id FROM user_friends WHERE user_id=1");

while($row=mysql_fetch_array($result){
//fetch every row returned by the select until you run out.
echo $row[0];
echo "<BR>";
}