SELECT * FROM tblPosts WHERE tblPosts.usersID = (SELECT tblFriends.friendsID WHERE tblFriends.myID = '$myID') ORDER BY tblPosts.date DESC;

This doesn’t through an error but it also doesn’t work. I think I need a join statement maybe? There are several fields in tblPost. ID, Comment, Date, userID, etc… Using my $myID variable I want to output <<<while($row = $result->fetch_assoc())>>> all the matching rows from tblPosts WHERE tblPosts.usersID equals every friend in my tblFriends.friendsID column when tblFriends.myID = ‘$myID’ and then ORDER BY tblPosts.date DESC? Any help would be great! Thank you.

>Solution :

Just join your tables:

select p.*
from tblFriends f
join tblPosts p on p.userID = f.friendsID
where f.myID = '$myID'
order by p.date desc;

Also note the use of short table aliases makes for a more compact and easier to read query.