I'm trying to make a homepage somewhat like Facebook, I made it so it could show the posts from the people I follow, but I couldn't see my own posts as I can't follow myself. Here is the line of SQL code I've written (it contains PHP variables):
SELECT *
FROM user_posts
INNER JOIN user_following ON user_posts.username = user_following.username
WHERE user_following.follower = '$me->username'
ORDER BY id DESC
LIMIT 0, 15
- The
user_posts
table contains all the posts. - The
user_following
table contains all follow data, whereusername
is the user being followed, and thefollower
is the user following theusername
-
$me->username
is the username of the user logged in.
user_following
table structure:
Thanks, in advance!