我在获取用户之间的共同好友以及在while循环中显示这些共同好友的图片、用户ID和姓名时遇到了很多问题。我几乎在共同的朋友上尝试了SO上的每一个答案,但当我混合了while循环所需的所有专栏时,一切都崩溃了。任何帮助都将不胜感激。
好友表:friend_id, friend_one, friend_two, date
用户表:uid, name_f, name_l, profile_pic
当用户将彼此添加为好友时,我会记录以下内容。假设用户1和用户2现在是朋友:
friend_one: 1, friend_two: 2, Date
friend_one: 2, friend_two: 1, Date
我需要以下内容,sql查询只为我返回共同好友的数量,但不能帮助我选择用户的uid、配置文件图片和名称:
$friends_sql=mysql_query("SELECT b.friend_two FROM (SELECT friend_two FROM friends WHERE friend_one = $myvar1) a INNER JOIN (SELECT friend_two FROM friends WHERE friend_one = $myvar2) b ON a.friend_two = b.friend_two");
while($friends=mysql_fetch_array($friends_sql))
{
something
?>
<li>
<img of user><p>name of user</p><a hre>link to user's uid</a>
</li>
<?php
}
?>
下一个代码适合您吗?
$friends_sql=mysql_query("SELECT b.friend_two FROM (SELECT friend_two FROM friends WHERE friend_one = $myvar1) a INNER JOIN (SELECT friend_two FROM friends WHERE friend_one = $myvar2) b ON a.friend_two = b.friend_two");
while($friends=mysql_fetch_array($friends_sql))
{
$getMutualFriendInfo = mysql_query("SELECT * FROM users WHERE uid='{$friends['friend_two']}'");
$MutualFriendInfo = mysql_fetch_array($getMutualFriendInfo);
?>
<li>
<img src="<?=MutualFriendInfo['profile_pic']?>"><p><?=MutualFriendInfo['name_f'] ?> <?=MutualFriendInfo['name_l'] ?></p><a href="/user.php?uid=<?=MutualFriendInfo['uid'] ?>"></a>
</li>
<?php
}
?>