jkewlo Posted April 21, 2009 Share Posted April 21, 2009 Hey cant seem to figure this out! I have users, following, and post all different tables It's kinda like Twitter I have users that can Follow other users but I need to get the users post that he/she is following Following Table user_id follower_id Users Table id Post Table id user_id I need to inner join the three tables so that user_id can get the followers post if you goto http://www.eve-lounge.com I just need to get the post from the users someone is following. Link to comment https://forums.phpfreaks.com/topic/155061-cant-get-no-help-in-the-mysql-section/ Share on other sites More sharing options...
Maq Posted April 21, 2009 Share Posted April 21, 2009 Maybe you're not receiving help because: - You never asked a question. - You didn't specifically mention what part you're having trouble with. - You didn't make any attempt. - Now you posted in the wrong section causing a double post which is annoying and wastes people's time if they read one and the other is solved. You need to join the tables and check the "user_id" on "Post Table" and grab the "id" for the post. I'm not sure why you want an inner join? Maybe I'm mistaken but I think a LEFT JOIN would work. Read more here: JOINS. Link to comment https://forums.phpfreaks.com/topic/155061-cant-get-no-help-in-the-mysql-section/#findComment-815566 Share on other sites More sharing options...
Recommended Posts