I'm having a little trouble getting this to work exactly how I want it to work. I have a table called users and then I have a table called friendships.
Every time someone sends a friend request and it gets accepted, the friendship is added to a log that contains requester,accepter.
Now I have a page where all users are located and you can friend them. How would I go about not showing people on this page that are already friended by me (through looking at the friendships table/logs).
Managed to fix it by using NOT IN together with an array containing all the friendship IDs.