fetch - Exclude myself from friendship page - MySQL -


this query fetch user's friends. there problem. if receiver session user returning friend.

select user.name_surname, user.id, friendship.receiver_id, friendship.sender_id user join friendship on user.id = friendship.receiver_id      (friendship.receiver_id =".$_session["ses_user_id"]." or friendship.sender_id =".$_session["ses_user_id"].")       , is_approved='1'" 

below table mysql table design. i'am logged on user_id =16 site. user_id=19 sent me frienship request. approved it. beautiful here when want see friends see myself friend.

how exlude myself @ friends page?

friendship table


attempted below

if change line

join friendship on user.id = friendship.receiver_id 

to

join friendship on user.id = friendship.sender_id 

this time user sent me friendship request sees his/her self his/her friend.

would

"and user.id != " . $_session["ses_user_id"] 

not do? whole query be:

select user.name_surname, user.id, friendship.receiver_id, friendship.sender_id user join friendship on user.id = friendship.receiver_id (friendship.receiver_id =".$_session["ses_user_id"]." or friendship.sender_id =".$_session["ses_user_id"] . ")  , is_approved='1' , user.id != " . $_session["ses_user_id"] 

edit: think query should be:

select user.name_surname, user.id, friendship.receiver_id, friendship.sender_id user join friendship on user.id = friendship.receiver_id , friendship.receiver_id != " . $_session['ses_user_id'] . " (friendship.receiver_id =".$_session["ses_user_id"]." or friendship.sender_id =".$_session["ses_user_id"] . ")  , is_approved='1' 

Comments