How do i query for mutual friends?

I have table friends **and table **users

Lets says a current user visit another user's profile and the profile id is 27

$user_id = $_GET['id'];

then I click on a link to view the friends of this user(27)

so now his friends are:

18 and 33

Note: user 18 is the current loggedIn user

Please how can I query database if current(18) user is also friends with user 33??
image

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion