我有一个文章页面,我只想显示每个帐户都在关注的用户的feed,有点像twitter。我要区分两个表一个叫posts
,另一个叫followers
我想循环的文章,但我希望它只选择用户,我的帐户是以下。我只需要SQL
查询,因为PHP
部分的其余部分我可以执行它
就像这样,虽然我知道这个不起作用
$connect->query("SELECT id,userid,postagem FROM posts WHERE IN (SELECT followed FROM followers WHERE whofollowed = '$userd' ) ORDER BY id DESC LIMIT 13");
假设followed
也是follower表中的userid:
$connect->query("SELECT id,userid,postagem FROM posts WHERE userid IN (SELECT followed FROM followers WHERE whofollowed = '$userd' ) ORDER BY id DESC LIMIT 13")