friend system?

friend system?

El Forum
Unregistered

#10

10-19-2007, 05:58 AM

[eluser]xwero[/eluser]
[quote author="thepyromaniac" date="1192808169"]I have a simple system for this. Have a FriendRequests table and a Friends table. Have userA and userB in both, userA does the requesting, userB is requested.

and friendships

Quote:SELECT * FROM Friends WHERE (userA = $userID AND userB = $friendID) or (userB = $userID AND userA = $friendID)

.

[/quote]

To get friendship data you need two ids but how do you get that second id if you only know the id of the person that is logged in?

Messages In This Thread

friend system? - by El Forum - 10-18-2007, 10:12 PM

friend system? - by El Forum - 10-18-2007, 11:59 PM

friend system? - by El Forum - 10-19-2007, 12:16 AM

friend system? - by El Forum - 10-19-2007, 12:40 AM

friend system? - by El Forum - 10-19-2007, 12:49 AM

friend system? - by El Forum - 10-19-2007, 12:54 AM

friend system? - by El Forum - 10-19-2007, 01:00 AM

friend system? - by El Forum - 10-19-2007, 03:25 AM

friend system? - by El Forum - 10-19-2007, 04:36 AM

friend system? - by El Forum - 10-19-2007, 05:58 AM

friend system? - by El Forum - 10-19-2007, 06:05 AM

friend system? - by El Forum - 10-19-2007, 06:08 AM

friend system? - by El Forum - 10-19-2007, 06:17 AM

friend system? - by El Forum - 10-19-2007, 10:37 AM

friend system? - by El Forum - 10-19-2007, 12:34 PM

friend system? - by El Forum - 10-19-2007, 12:47 PM

friend system? - by El Forum - 05-13-2010, 10:13 AM