mySQL: need help understanding WHERE AND OR

[Dennis_gull]

Hello everyone,
I've been doing some php programming lately and I have come in contact with a problem.
I have a table called "friends" and in that table I got 'user_id' and 'friend_id', I now want to do a query to see if two id's match, like this:

$sql = "SELECT id FROM friends WHERE user_id = $me AND friend_id = $someone";
$result = mysqli_query($this->db,$sql);
$length = mysqli_num_rows($result);
mysqli_free_result($result); 

The only problem now is that the current user can only be 'user_id', so I think I may be able to use the OR statement to select rows with either $me/$someone as user_id or friend_id.. is this possible?

[aguroyz]

whats the friend id for??

[SoulScratch]

WHERE user_id = $me AND friend_id = $someone OR user_id = $someone AND friend_id = $me

Not exactly sure, but is this close to what you're looking for? Could you provide more examples/info?

[Dennis_gull]

whats the friend id for??

I use the "friends" table to link two users together so the one who invited the other friend is 'user_id' and the friend is 'friend_id'.

WHERE user_id = $me AND friend_id = $someone OR user_id = $someone AND friend_id = $me

Not exactly sure, but is this close to what you're looking for? Could you provide more examples/info?

I think thats exactly what I'm looking for, Thanks for the help.

[aguroyz]

did soulscratch code worked??

[Dennis_gull]

did soulscratch code worked??

Yeah it works perfectly.

[SoulScratch]

Awesome.