PHP SELECT FROM multiple tables

Question

I have a article pages, that i only want to show feed of the users that every account is following, kinda like twitter. I have to distinct tables one is called posts other is called followers I want to loop the articles but i want it to select only the users that my account is following. I just need the SQL query that can do that since the PHP part of the rest i can perform it

Something like this , although i know that this one does not work

$connect->query("SELECT id,userid,postagem FROM posts WHERE IN (SELECT followed FROM followers WHERE whofollowed = '$userd' )  ORDER BY id DESC LIMIT 13");

leeor · Accepted Answer · 2015-10-11 21:44:14Z

1

Assuming followed is also a userid in the followers table:

$connect->query("SELECT id,userid,postagem FROM posts WHERE userid IN (SELECT followed FROM followers WHERE whofollowed = '$userd' )  ORDER BY id DESC LIMIT 13")

answered Oct 11, 2015 at 21:44

leeor

18k6 gold badges36 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user1056621 Over a year ago

the userid must match in both

leeor Over a year ago

the query is saying "select all the posts of followed userids who are followed by the provided userid". You only need to match the provided userid against the followers table to get the userids which that user is following.

user1056621 Over a year ago

Its not looping, i need it to loop all posts that in followed the whofollowed have my username

Collectives™ on Stack Overflow

PHP SELECT FROM multiple tables

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related