I'm running into a problem with developing my site.
People can become friends of one and eachother and I want these people to see their friends a a specific page.
I have two tables:
Table 1: Friends
Table 2: users
People are friends once their ID is in user_1 or user_2 and both states are set to '1'.
Now I need to connect to the database and make a query where it pulls your friends ID and connects this to the users databes to get First_Name, Last_Name, etc.
How do I do this?
One of the problems is that the friends ID can be in column user_1 or user_2, so how do I filter this?
I saw a questions pretty similiar to mine, with a good answer, but just couldn't get this to work!
Hope you guys can give me some help!