|
Currently I am in need to find the friends of friends in my application using PHP and MYSQL
For example : Database structure is like this. Table Name : tbl_friendlist
Ident mem_id friend_id 1 2 1 2 1 2 3 1 3 1 4 1 5 1 8
How can i achieve this
I am able...
Started by Fero on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
These are the two ....
Your friends
SELECT friend_id FROM tbl_friendlist WHERE f.mem_id = 1
And so then you just wrapSo, breaking into steps -- you want to find all your friends, and then you want to find all of their friends.
|
|
Hello.
I have two tables.
USER user_id password
FRIEND_LIST user_id friend_id
If user 1 is friend of user 2 then in friend_list there will be 2 records:
1 2 2 1
Thats how I'm controlling friend list.
My question is how can I create an efficient query ...
Started by Enrique on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
(editThe query you already wrote....
It would be a bit tougher if each pair of friends only got one row in friend-list ....
You have two complementary entries in friend-list for each pair of friends, the query is nice and simple.
|
|
Started by Andrroid on
, 64 posts
by 38 people.
Answer Snippets (Read the full thread at reddit):
Thus, many of us didn't know one.
By invite only, most of the users are friends of friends etc.
So the relationship basis between this group of friends is defined.
Of decently sized phones disturbing.
|
Ask your Facebook Friends
|
Hi
I have this problem. Given a users table that consists of users' username in a social network and friends table that contain a user's name and a user's friendname like below...
username friendname John Thomas Chris James
... I'm trying to write an ...
Started by core_pro on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If the friendship relationship is symmetric, you should make the following query... .
SELECT * FROM ( SELECT username FROM friends START WITH username = 'myname' CONNECT BY friendname as necessary: you may search for the third layer friends etc.
|
|
Hi folks,
I'm not so into this social media stuff, so I'll describe the task here.
I plan an application, that needs the social graph between two indiviuals in order to work. The first one is the user of the application, which provides us with access ...
Started by Steve|munich on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at wickedfire):
MyBrainIsFullOfFuck.jpg
srs, why would you even want to do such a thing? Unless B & C are openly ... .
|
|
Welcome to the 4th Nina &
Friends apprecation thread.
From Matt Lanter, to Chris Colfer and others, here's a thread to talk about Nina and all her friends!
Started by ~ Fire & Ice ~ on
, 15 posts
by 5 people.
Answer Snippets (Read the full thread at fanforum):
If you don't remember or don't even know me I'm Norma I love that Nina was today with her friends.
|
|
Enjoying these games ! Looking for more friends!
I'm Bethcatlim if anyone wants to play.
Answer Snippets (Read the full thread at twopeasinabucket):
Started....
I have a lot of games play Dice with Buddies .
Huskergal27 Words with Friends: lebakke I'm already playing with you with Hanging.
I am susannjlaw Words with Friends.
Start a game with me! Scrapbean i play words with friends.
|
|
I got this from an email from a buddy. Thought I would pass it on.
CIVILIAN FRIENDS: Tell you not to do something stupid when drunk.
MARINE FRIENDS: Will post 360 security so you dont get caught.
CIVILIAN FRIENDS: Call your parents Mr. and Mrs.
MARINE...
Started by LNGBWFLYR on
, 14 posts
by 6 people.
Answer Snippets (Read the full thread at military):
That....
May I have a copy? KNOCK-KNOCK!!!!
Permission to enter?
What's it take to get a GRUNT of my friends on Facebook.
M60A1 Rise Passive Tanker Knock- Knock..
|
|
Feel free to describe why and how.
I hear childhood friends are the main reason.
Started by Overanalyzer on
, 25 posts
by 25 people.
Answer Snippets (Read the full thread at intjforum):
No oneI have seven near-true....
I have buddies and acquaintances, but no friends.
A friend is a strong word in my dictionary.
I suppose in a sense I am friends.
People who consider me their real friend 2.
Real friends 0.
|
|
You're gonna have fun watching iron man, jas .
latest pictures of jake out to lunch with his friends
Started by teena1013 on
, 15 posts
by 3 people.
Answer Snippets (Read the full thread at fanforum):
No idea but i'm sure jake's been friends been friends with them for quite a while now.
I don't think i know anyone who hasn't watched iron man yet .
|
