ok, so i have a members_friends table. like this:

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.
What i need to do is look through the database to see if member '4' has friend '1' as a friend.

How do i do this?