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?

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
Post a Comment