|
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):
SELECT * FROM ( SELECT username FROM friends START WITH username = 'myname' CONNECT BY friendname = PRIOR username AND level <= 3 ) WHERE username = 'friendname' AND rownum = 1
Update the level as necessary: you may search for the third layer....
|
|
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):
If you need to find a way without.
Your friends
SELECT friend_id FROM tbl_friendlist WHERE f.mem_id = 1
And so then you just wrap mem_id in (SELECT friend_id FROM tbl_friendlist WHERE mem_id = 1).
|
|
Tell you friends. Then your friends friends. Sold thanks all ! Last edited by redliner; 02-13-2012 at 07:02 PM .
Started by redliner on
, 28 posts
by 15 people.
Answer Snippets (Read the full thread at reality-check):
Nice spot! i like....
Sold Last edited by redliner; 02-13-2012 at 07:03 PM.
Sold ! Last edited by redliner; 02-13-2012 at 07:03 PM .
Brand new schools in the area,and close to everything.
I Grew up just outside of Nine mile river.
Nice quite place to live.
|
Ask your Facebook Friends
|
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...
Started by jasondavis on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You do a subquery:
SELECT DISTINCT user_id FROM friends WHERE friend_id IN (SELECT user_id FROM friends WHERE friend_id = 1)
Test both of these for performance:
SELECT DISTINCT user_id FROM friends FROM friends....
|
|
Hi,
I've recently stared looking into the Facebook API and am trying to workout how to retrieve the list of friends of another user (in this case the user is someone I'm friends with).
So far I've only worked out how to find out the friends of a person...
Answer Snippets (Read the full thread at stackoverflow):
It looks like Friends.get is what you want..
Http://wiki.developers.facebook.com/index.php/Friends.get
See the uid optional parameter.
|
|
In C++, I have a class A which is friend with a class B.
I looks like inherited classes of B are not friend of class A.
I this a limitation of C++ or my mistake ?
Here is an example. When compiling, I get an error on line "return new Memento":
Memento...
Started by Jérôme on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
(See also " friendship isn't inherited, transitive, or reciprocal ")
The friend directive was originally intended as some "loophole" to bypass the encapsulation....
Friendship is not inherited, you have to explicitly declare every friend relationship.
|
|
I wrote a script to export twitter friends as foaf rdf description. Now I'm looking for a tool to visualize the friend networks. I tried http://foafscape.berlios.de/ but for 300+ Nodes it is really slow and does a bad job on auto formatting.
Any hints...
Started by Peter Hoffmann on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
In one of the talks at dConstruct08 last week there was a social graph showing the friend for some flare examples, there is a friend of a friend graph around there..
Social Graph.
|
|
U have lot of good friends inside the campus or outside the campus . All r Ur best friend?
Started by raju on
, 15 posts
by 8 people.
Answer Snippets (Read the full thread at daffodilvarsity):
Finally, Best friends means the one friend who there for you and ....
Better means who thinks more than for your welfare.
The person who has at least one such best friend is amongst.
A friend in need is a friend in deed.
|
|
Friend poll: how many do you consider "close friends"?
Started by *-starlicious-* on
, 18 posts
by 18 people.
Answer Snippets (Read the full thread at yahoo):
Around here, there are "acquaintances" and family, friend isn't used much, cause if they true enough to be a "friend", they considered family lol i was trolling ur question earlier...u r like way 2, Lilyn and Caitlyn Eh 1 i guess but they....
|
|
Scramble with Friends >>> Words with Friends In my expert opinion.
Started by Ridic Too on
, 19 posts
by 9 people.
Answer Snippets (Read the full thread at dawgsaloon):
Originally Posted by Schmoopy Scrambled eggs....
Also Drawing with Friends and Hanging with Friends.
Jaw Bone---> <---Gumz yeah, people can't cheat on scramble Scrambled eggs with bacon > Scramble With Friends I like it a lot.
|
