dannyb785 Posted June 21, 2012 Share Posted June 21, 2012 I'm making a social network site and I want the newsfeed page to have wall posts that 1) I've made to friends, 2) that friends have made to me, and 3) that friends have made to other friends. I have code for #1 and #2, but I don't know how to do #3. I feel like the only way is to have an entry for every possible friend combination where if: user1 is friends with user2, user3, user4, and user5 that I'd have to check for wall posts where: (wall_user=user2 AND wall_poster=user3) OR (wall_user=user3 AND wall_poster=user2) OR (wall_user=user2 AND wall_poster=user4) OR (wall_user=user4 AND wall_poster=user2) and so on down the line of every possible combination Is there an easier way? Link to comment https://forums.phpfreaks.com/topic/264575-checking-other-friends-wall-posts/ Share on other sites More sharing options...
xyph Posted June 21, 2012 Share Posted June 21, 2012 Check out JOINs. That's what you want Link to comment https://forums.phpfreaks.com/topic/264575-checking-other-friends-wall-posts/#findComment-1355936 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.