Jump to content

Friends Of Friends System


davidb52
 Share

Recommended Posts

Hello,first of all sorry for bad english.But I am trying to make a friend of friend system.Like this:usersf table:id friends0 11 02 11 2 just for example some more:0 33 05 00 52 44 2 so 0/2 are friend with 1, 2 isn't friends with 0 but with 1(and 1 is friend with 0).How could I make a query that return true (or count higher than 0) if I want to know if they are friend of friend.LikeSelect friend where id=0Select friend where id=2if results are the same return true, because they both will have a friend 1 as result.If you don't get me look at this: http://stackoverflow.com/questions/1451868/how-create-sql-query-that-validates-friends-of-friends .The problem with the link is that I don't now how to use (the best answer) for my database. Thanks, David

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...