Two SELECT/WHERE clauses combined?

I’m not very good with MySQL statements, so I’m looking for some insight. Let’s say a user visits someone else’s page. This will send the username as a parameter to a script to check if the current user and the user’s page they are visiting are friends.

My simple database structure:

FRIENDS TABLErelationship_id, friend1_ID, friend2_ID, status

ACTIVE_USERS TABLEid, username, email…etc.

My current SQL statement is as follows:

SELECT * 
FROM friends
JOIN active_users ON ( active_users.username =  '$username' ) 
WHERE (
    friends.friend_1ID = '$current_user_ID'
    AND friends.friend_2ID = active_users.id
    AND friends.status = 1
)

While this WORKS, I don’t feel it’s elegant. It returns a row if the two are friends, but this row obviously is a join of the user information row and the relationship row. I would just like to grab the relationship row. Would it be economical to break this up into two statements? For instance, I would query for the visited page’s user ID using the username, and then use that variable in a second statement to grab the relationship. Or is there an easier syntax I have not come across? Help is appreciated!

Leave a Reply

*

Hire Me
Follow Me!
Search
Most Popular Articles & Pages
Because your vote is Important
Sorry, there are no polls available at the moment.
Categories