Stack Overflow
Stack Overflow

Questions tagged [mutual-friendship]

Use this tag for questions regarding mutual friendship in a Social Networking Service sense, whether implementing one's own or using a third-party service's API.

18 questions
10
votes
11 answers

MySQL query for mutual friends

Possible Duplicate: MYSQL select mutual friends I have a table for friendship, the friendship is stored only in one line. So there is no duplicate entries. id Person1 Person2 status 1 1 2 friend 2 1 3 …
ilhan
  • 8,700
  • 35
  • 117
  • 201
4
votes
3 answers

Finding mutual friend sql

Actually, I have 2 tables the friend table and the users table what I try to achieve is to retrieve my mutual friend by checking the friend of another user and get the data of these mutual friends from the user's table table friend is built like…
Mireille28
  • 337
  • 5
  • 13
2
votes
1 answer

MYSQL select mutual friends

My 'friends' table has the following columns: id, userID, userID2, state userID and userID2 don't have a specific order of being put into the database. I currently use this query to find a users friends: $quer = mysql_query(" SELECT CASE WHEN…
Dylan Cross
  • 5,918
  • 22
  • 77
  • 118
2
votes
2 answers

Find the number of mutual friends in Python

I have a dataframe of users and their friends that looks like: user_id | friend_id 1 3 1 4 2 3 2 5 3 4 I want to write a function in python to compute the number of mutual friends for each pair: user_id |…
CWuu
  • 23
  • 1
  • 3
1
vote
1 answer

Laravel How to find Mutual Friends from model?

I am using laravel 8. I want to find the mutual friends of entries and profiles. Please ask me if it is not clear... My friends table; user_friends; id | user_id | user_friend_id 1 | 10 | 20 2 | 20 | 10 In My User Model; public…
furkankufrevi
  • 39
  • 10
1
vote
1 answer

Mutual Friends - MySQL

I am trying to develop a function which shows me friends of friends, and how many mutual friends I have with those users. So far, I have been able to do the functions separately but not together. Here is the main view I am using called userfriends.…
MichaelH
  • 1,600
  • 3
  • 14
  • 20
1
vote
3 answers

rails activerecord, friend relation + inverse_friend relation how to get the mutual relation? code included

Trying to find the mutual relation, In a friends relations, Already have friends and inverse_friends. But how to combine them to get the mutual friends? Cannot seem to figure it out I tried several options and searched long time online, just don't…
Rubytastic
  • 15,001
  • 18
  • 87
  • 175
0
votes
3 answers

What function in Social Graph loads mutual friends so fast?

I am making a Facebook application for which I require the mutual friends of the logged in user. The Old API friends.getMutualFriends does the work but it is very slow. I was wondering if there is any other way of getting the list of mutual friends.…
mehwish nasim
  • 111
  • 4
0
votes
1 answer

Facebook API v6.0 to find mutual friends

With the most recent version (6.0) of the Facebook Graph API, there are no longer endpoints to find mutual friends between two users or get the friends list of a user. If I want to find the number of mutual friends of two users on my app, how would…
slick_reaper
  • 192
  • 8
0
votes
1 answer

Optimizing query to find mutual friends in Facebook

Assuming a Facebook friend's table looks like this - userId | friendId, how would you write a SQL query to find the mutual friends between two friends? I have the below code that works for two friends A and B. However, I feel like it is not…
needdemhelps
  • 11
  • 1
0
votes
0 answers

How to return a queryset of friend requests in DRF ListAPIView?

I am using this django app in my django rest framework(DRF) backend api to manage bi-directional friendships between users of my android app. In one of my DRF views I want to return a queryset of all a user's unread friend requests. In the…
Tom Finet
  • 2,056
  • 6
  • 30
  • 54
0
votes
1 answer

context.fields(all_mutual_friend) returns Unsupported get request

I'm trying to get all mutual friends between me and other (not my friend) user. To do it i use a php server connecting with graph.facebook.com (REST client) I'm using the AppSecret from dashboard I'm sending valid access_token (with user_friends…
Bamboo
  • 1
  • 1
0
votes
1 answer

MYSQL - Work out & Count mutual friends

I’m having a little bit of a brain fart this evening trying to work out my logic. I need to count how many friends a person shares with one user. (Mutual friends) I have a table with a User ID and also the User ID of a friend, an example of my…
Martin Sheen
  • 25
  • 4
0
votes
2 answers

Facebook API - Mutual Friends

Is there a way to retrieve a list of mutual friends between /me/ and a certain {facebook id} I thought this was possible with 1.0, but am wondering if it can still be done with 2.0
MikeSig7
  • 37
  • 1
  • 5
0
votes
1 answer

How to get mutual friends on facebook?

I was searching for any way to get the mutual friends on facebook and i got this one https://developers.facebook.com/tools/explorer/?method=GET&path=me%2Fmutualfriends%2F&version=v2.0 But i found out that it is deprecated !! although Tinder got…
Iman
  • 1,097
  • 2
  • 11
  • 19
1
2