PHP MySQL query JOIN HELP

Question

Hey everybody. So, I'm creating this kind of a social network script for a project of mine and i need it to display a news feed similar to facebooks feed, that is, to display your friends posts and your own posts...but with my technique it only displays friends post.

my query is the following:

SELECT 
                * 
            FROM 
                ajee_friends
            JOIN
                ajee_wall
            ON
                ajee_friends.fid = ajee_wall.uid
            WHERE 
                ajee_friends.uid = '$this->uid'

@Ikke he wants to display friends posts and his own posts, this only displays his friends posts. — martynthewolf
– martynthewolf, Commented May 20, 2011 at 8:11
SELECT * FROM ajee_friends JOIN ajee_wall ON ajee_friends.fid = ajee_wall.uid AND ajeee_firends.fid = this->uid WHERE ajee_friends.uid = '$this->uid' if got it right — kskaradzinski
– kskaradzinski, Commented May 20, 2011 at 8:11
i will try skowron-line-s way, the problem is, that it doesnt show my own posts. — CodeInACan
– CodeInACan, Commented May 20, 2011 at 8:13

ZoolWay · Accepted Answer · 2011-05-20 08:16:57Z

5

If you want the wall of your friends and your own this can be done (in my opinion more readable as subselect):

SELECT *
  FROM ajee_wall w
 WHERE w.uid IN (SELECT fid FROM ajee_friends WHERE uid = $this->uid)
    OR w.uid = $this->uid

answered May 20, 2011 at 8:16

ZoolWay

5,5556 gold badges44 silver badges84 bronze badges

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

1 Comment

ZoolWay Over a year ago

Of course you will want to limit the ammount and also add something like a date condition. But this should be the basic.

ypercubeᵀᴹ · Accepted Answer · 2011-05-20 08:23:06Z

2

    SELECT *
    FROM ajee_wall w
    WHERE w.uid IN
        ( SELECT fid 
          FROM ajee_friends
          WHERE uid = $this->uid
        )
UNION ALL
    SELECT *
    FROM ajee_wall w
    WHERE w.uid = $this->uid

answered May 20, 2011 at 8:23

ypercubeᵀᴹ

116k19 gold badges181 silver badges248 bronze badges

2 Comments

ypercubeᵀᴹ Over a year ago

@Asko: @Zoolway 's answer is equivalent (and shorter). Just check which one runs faster in your db (if that's an issue) or keep both saved somewhere.

CodeInACan Over a year ago

I don't know, they both seem same fast to me. And great thanks to you all!

Bobby Stenly · Accepted Answer · 2011-05-20 08:21:58Z

0

I think you can use Union all... something like,

SELECT * FROM ajee_friends UNION ALL SELECT * FROM ajee_wall

It'll show all of your post and your friends'. You can make it show just a few lines with limit.

answered May 20, 2011 at 8:21

Bobby Stenly

1,2883 gold badges13 silver badges23 bronze badges

Collectives™ on Stack Overflow

PHP MySQL query JOIN HELP

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related