[SOLVED] Multiple where statements

[xstevey_bx]

I have a friends table

iduser_idfriend_idactive

1121

2211

3131

 

I want to delete a friend connection

 

$query = "DELETE FROM friends WHERE user_id='$_SESSION[uid]' AND friend_id='$fid'";
$result = mysql_query($query);

 

How do I delete the connection for the deleted friend too? Sort of like

 

Delete From friends where user_id="This user" AND friend_id ="old_friend" [AND WHERE] user_id="old_friend" AND friend_id="This user"

[rhodesa]

$query = "DELETE FROM friends WHERE (user_id='$_SESSION[uid]' AND friend_id='$fid') OR (user_id='$fid' AND friend_id='$_SESSION[uid]')";

[xstevey_bx]

Thank you so much!