如果隐私设置为好友,如何显示自己的帖子


How to show own posts if privacy is set to friends

这是我的SQL查询:

$result = mysql_query("
    SELECT t.tid, t.title, t.time, t.authorid, t.photo, f.fuid, f.myuid, u.username as writer 
      FROM topics as t, friends as f, users as u 
     WHERE cid='$cid' 
       AND u.id=t.authorid 
       AND (
               f.fuid=t.authorid AND f.myuid='$myid' 
               OR
               f.myuid=t.authorid AND f.fuid='$myid'
           ) 
  ORDER BY tid DESC 
     LIMIT $start, $perpage
");

我只在朋友发布内容时得到输出,但在我发布时没有得到任何内容。我的朋友可以查看我的更新,但我自己不能。

如果没有更多信息(例如示例数据),我会说:尝试以下操作:

$result = mysql_query("
    SELECT t.tid, t.title, t.time, t.authorid, t.photo, f.fuid, f.myuid, u.username as writer 
      FROM topics as t, friends as f, users as u 
     WHERE cid='$cid' 
       AND u.id=t.authorid 
       AND (
               f.fuid=t.authorid AND f.myuid='$myid' 
               OR
               f.myuid=t.authorid AND f.fuid='$myid'
               OR
               t.autorid='$myid'
           ) 
  ORDER BY tid DESC 
     LIMIT $start, $perpage
");