PHP MySQL 查询 JOIN HELP

发布于 2024-11-09 07:43:14 字数 395 浏览 0 评论 0原文

嘿大家。所以，我正在为我的一个项目创建这种社交网络脚本，我需要它来显示类似于 Facebook 提要的新闻提要，即显示您朋友的帖子和您自己的帖子......但是用我的技术它只显示朋友的帖子。

我的查询如下：

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

原文

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'

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

感情废物 2024-11-16 07:43:14

如果你想要你的朋友和你自己的墙，可以这样做（在我看来，作为子选择更具可读性）：

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

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

回复收藏 0 原文

小清晰的声音 2024-11-16 07:43:14

    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

    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

回复收藏 0 原文