我如何显示谁是在用户的朋友列表中的人在PHP的帖子 - How do i display the posts by people who are in the friend list of the user in PHP?

How do i display the posts by people who are in the friend list of the user in PHP?

我有两个名为" posts "answers" friends "的表。我想显示我的代码——

        $yyss = mysql_query("select * from friends where friend_id='$emaild' or user_id='$emaild'");
    $rp = mysql_num_rows($yyss);
    $fk = mysql_query("select * from friends where friend_id='$emaild' or user_id='$emaild' limit 3");
    while($nr = mysql_fetch_assoc($fk)){
    $frid=$nr['user_id'];
    $ffr = $nr['friend_id'];
    $sql = mysql_query("SELECT * FROM posts where id='$frid' or id='$ffr' order by unid desc");
}

如何显示由用户的朋友发布的帖子而不是一次又一次地显示它们?

 $friends = mysql_query("SELECT * FROM friends WHERE friend1 = '$my_uid'"); 
 while($friend = mysql_fetch_assoc($friends)){
     $f[] = $friend['friend2']; 
 }
 $posts = mysql_query("SELECT * FROM posts WHERE owner_id IN
 (".implode(",", $f).")");