i wonder how the user and his friends list are built using databases.
is this the way.. or if there is a better solution please tell me
users(id, name, email, username, password)
freinds(id, user_id, friend_id, status)
main think i wonder is ...
Lets say A sent a friend request to B .. and B accepted it and they are friends.. when populating the friends list on their respective profile how to get the friends when B is refernced under friend_id... and not under user_id.. since A had sent the request.