因此,我有一个名为follow_sys
的表,其中包含列id
、follower
和following
,我想要显示我关注的人,但不要将其作为待处理的好友请求返回。我尝试了自连接,但它不起作用
$sqlFollowing = "SELECT * from follows_syds t1, follows_syds t2
where
t1.follower = ?
and
t1.following != ?
and
t2.follower != ?
AND
t2.following != ?";
$Following = $conn -> prepare($sqlFollowing);
$Following -> bind_param('ssss',$metUser,$metUser,$metUser,$metUser);
$Following -> execute();
$FollowingGET = $Following -> get_result();
$FollowingRows = $FollowingGET -> num_rows;
我试过这样的方法,但结果仍然不准确
$sqlFollowing = "SELECT * from follows_syds t1
INNER join follows_syds t2 on
t1.follower = t2.following
where
t2.follower = ?
and
t1.following = ?
group by t2.id";
$Following = $conn -> prepare($sqlFollowing);
$Following -> bind_param('ss',$getUser,$getUser);
$Following -> execute();
$FollowingGET = $Following -> get_result();
$FollowingRows = $FollowingGET -> num_rows;
while($b = $FollowingGET -> fetch_assoc()){
$ve = $b['following'];
}
$sqlowing = "SELECT * from follows_syds t1
INNER join follows_syds t2 on
t1.follower = t1.follower
where
t2.follower = ?
and
t2.following != ?
AND
t1.follower != ?
and
t1.following != ?
group by t2.id";
$owing = $conn -> prepare($sqlowing);
$owing -> bind_param('ssss',$getUser,$ve,$ve,$getUser);
$owing -> execute();
$owingGET = $owing -> get_result();
$owingRows = $owingGET -> num_rows;
while($a = $owingGET -> fetch_assoc()){
print_r($a );
echo "</br>";
}
https://stackoverflow.com/questions/51124680
复制相似问题