如何在PHP中获取好友列表？

my sql query i am using this type of query i am getting friends like who sent friend rquest for me and accepted by me.but i did not get friends when i sent friend request for friends and accepted by friend

My tables are as so

First table 'user_details'
id
firstname
lastname
username

second table 'friendslist'
sno
userid
friendid
status (1 for friend)


$id=$_SESSION['id'];
    $query="select * from friendslist f INNER JOIN user_details u on f.userid=u.id where f.status='1' AND  f.friendid='$id'";

    $select=mysql_query($query);
    if(mysql_num_rows($select)>0){
        while($result_temp=mysql_fetch_assoc($select)){
        $resultnewfriend[]=$result_temp;
        }
    }else{
        $resultnewfriend=array();
    }   
    return $resultnewfriend;

according to your question you want to get current user friend list

"select * from friendlist where user_id=$id"