ok, so i have a members_friends table. like this:
What i need to do is look through the database to see if member '4' has friend '1' as a friend.Code:member_id friend_id
------------------------
1 | 4
2 | 4
3 | 4
This meaning, That member '4' is friends to 1, 2, 3.
member_id friend_id
------------------------
4 | 1
4 | 2
4 | 3
This meaning that Members 1, 2, 3 are friends of 4.
How do i do this?
