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.