สอบถามการดึงข้อมูลหรือโพสต์ที่มีการตั้งค่า privacy

<div id="profile_contain">

<?php 
			  
			  $strSQLmember = "SELECT * FROM member WHERE member_id = '$member_id'";
			  $resultmember = mysql_query($strSQLmember)or die(mysql_error().$strSQLmember);
			  $rowmember=mysql_fetch_array($resultmember);
			  //echo $rowmember['member_name'];
			  $strSQL = "SELECT * FROM topic WHERE member_id = '$member_id'";
			  $result = mysql_query($strSQL)or die(mysql_error().$strSQL);
			  
				$Num_Rows = mysql_num_rows($result);
				
				$Per_Page = 10;   // Per Page
				
				$Page = $_GET["Page"];
				if(!$_GET["Page"])
				{
					$Page=1;
				}
				
				$Prev_Page = $Page-1;
				$Next_Page = $Page+1;
				
				$Page_Start = (($Per_Page*$Page)-$Per_Page);
				if($Num_Rows<=$Per_Page)
				{
					$Num_Pages =1;
				}
				else if(($Num_Rows % $Per_Page)==0)
				{
					$Num_Pages =($Num_Rows/$Per_Page) ;
				}
				else
				{
					$Num_Pages =($Num_Rows/$Per_Page)+1;
					$Num_Pages = (int)$Num_Pages;
				}
				
				$strSQL .=" order by topic_id DESC LIMIT $Page_Start , $Per_Page ";
				$result  = mysql_query($strSQL);
	  
			  while ($row=mysql_fetch_array($result)){
			  $topic_id = $row['topic_id'];
			  //echo $row['topic_name'];			  

			  ?>
              
            
<div class="profile_wall">
<div class="pic_profile">
<?php if($rowmember['member_pic'] == ''){?>
                    <img src="images/bgprofile1.jpg" width="50" height="50" />
                    <?php }else{?>
                    <img src="myfile/<?php echo $rowmember["member_pic"];?>" width="50" height="50" />
                   <?php } ?>


</div>

<div class="text_profile">
<span> <?php echo $rowmember['member_name']?></span>                    
<span><?php echo $row['topic_date']; ?></span>
<span style="float:right"><form id="form1" name="form1" method="post" action="profile_wall_del_confirm.php?idMem=<?php echo $topic_id;?>">
                         <input name="txttopic_id" type="hidden" value="<?php echo $topic_id; ?>" />
                         <input type="submit" name="Submit" id="button" value="ลบโพสต์" class="btn btn-default"/>
                         </form></span>

</div>
<div class="text_profile2">
<!--<a href="news_feed_comment.php?topic_id=<?php echo $row["topic_id"];?>" style="text-decoration:none" >&nbsp;&nbsp;-->
                      <?php  echo $row['topic_name']; ?>
                      </a> </br>
<span style="float:right"><input type="button" name="button" id="button" value="อ่านรายละเอียดโพสต์" onclick="window.location='news_feed_comment.php?topic_id=<?php echo $row["topic_id"];?>'" class="btn btn-default"/> </span>
</div>
</div>

<!--<div align="right">
                       <form id="form1" name="form1" method="post" action="well_del_confirm.php?idMem=<?php echo $topic_id;?>">
                         <input name="txttopic_id" type="hidden" value="<?php echo $topic_id; ?>" />
                         <input type="submit" name="Submit" id="button" value="ลบโพสต์" />
                         </form>
</div>-->   

<div>

</div>                       

<?php			  
			  }
			  ?>
			       
</div>
<div>
ทั้งหมด
<?= $Num_Rows;?>
โพสต์หน้า :&nbsp;
              
              <!--: หน้าที่ -->
			  <?
			  //$Num_Pages;
			  ?> 
              <?
              if($Prev_Page)
              {
                  echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< ก่อนหน้า</a> ";
              }
              
              for($i=1; $i<=$Num_Pages; $i++){
                  $Page1 = $Page-2;
                  $Page2 = $Page+2;
                  if($i != $Page && $i >= $Page1 && $i <= $Page2)
                  {
                      echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
                  }
                  elseif($i==$Page)
                  {
                      echo "<b> $i </b>";
                  }
                                              }
              if($Page!=$Num_Pages)
              {
                  echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>ถัดไป >></a> ";
              }
			?>
</div>

จากโค้ดเป็นการดึงโพสต์ทั้งหมดของผู้ใช้มาเเสดง โดยที่ไม่ได้กำหนด topic_privacy ถ้าต้องการจะกำหนด topic_privacy เข้าไปด้วยไม่ทราบต้องเพิ่มเติมอย่างไรบ้างค่ะ 

<div id='newsfeed_contain'>
<div class='block_news_add_new'>

<form id="form2" name="form2" method="post" enctype="multipart/form-data" action="add_topic.php" onsubmit="return fncSubmit();">

<div class="panel panel-default">
  <div class="panel-body" >

  <table width='650px' >
<tr>
<td valign='top' width="160px"><label for="exampleInputPassword1">ชื่อโพสต์:</label></td>
<td valign='top'>
                    <input name="txttopic_name" type="text" id="textfield" value=""  class="form-control" placeholder="พิมพ์ชื่อโพสต์" />
                  </td>
</tr>
</table>
</div>

  <div class="panel-body">
  <table width='650px' >
  <tr>
<td valign='top' width="160px" ><label for="exampleInputPassword1">รายละเอียดโพสต์:</label></td>
<td valign='top'>
                    <textarea name="txttopic_detail" cols="70" rows="10" id="txttopic_detail" class="form-control" placeholder="พิมพ์รายละเอียดโพสต์"   ></textarea>
                  </td>
</tr>
  </table>
  </div>
  
  <div class="panel-body">
  <table width='650px' >
  <tr>
<td valign='top' width="160px" ><label for="exampleInputPassword1">รูปภาพ/วิดีโอ:</label></td>
<td valign='top'>เเนบไฟล์หรือรูปภาพ &nbsp;</br> <input type="file" name="QPic" OnChange="showPreview(this)"  on />

</td>
</tr>
  </table>
  </div>

  <div class="panel-body-new">
  <table width='650px' >
  <tr>
  <td valign='top' width="160px"><label for="exampleInputPassword1">ตั้งค่าความเป็นส่วนตัว:</label></td>
  <td valign='top'><ul class="list-group">
  <li class="list-group-item"><input type="radio" name="topic_privacy" id="topic_privacy0"  value="0">&nbsp;เฉพาะเพื่อน</li>
  <li class="list-group-item"><input type="radio" name="topic_privacy" id="topic_privacy1"  value="1">&nbsp;เฉพาะฉัน</li>
</ul>
  </td>
  </tr>
  </table>
  </div>
  
  <div class="panel-body">
  <table width='650px' >
  <tr>
<td colspan="2" valign='top'> <input name="Submit" type="submit" class="btn btn-default" id="Submit" value="   โพสต์   " /> 
<input name="Cancel" type="button" value="ยกเลิกการโพสต์" onClick="window.location='profile_wall.php'" class="btn btn-default"/ > 
</td>
</tr>
</table>
  </div>
  
</div>

    </form>
           
</div>

</div>

ต้องการทราบว่าตอนที่ดึงข้อมูลมาเเสดงไม่ทราบว่าต้องทำอย่างไร ถึงจะเป็นไปตาม topic_privacy ที่ตั้งไว้ค่ะ
ไม่ทราบว่าพอจะเข้าใจรึป่าวค่ะ  ^^ 

<!--css style-->
<?php include_once 'js.php';?>
<?php 
			  
			  $strSQLmember = "SELECT * FROM member WHERE member_id = '$member_id'";
			  $resultmember = mysql_query($strSQLmember)or die(mysql_error().$strSQLmember);
			  $rowmember=mysql_fetch_array($resultmember);
?>	

<div class="head_on_page_right"><h4>โพสต์ ทั้งหมดของคุณ&nbsp;<font color="#009EE3"><? echo $rowmember['member_name'] ?></font></h4>
</div>
<div id="profile_contain">

<?php 
			  
			  $strSQLmember = "SELECT * FROM member WHERE member_id = '$member_id'";
			  $resultmember = mysql_query($strSQLmember)or die(mysql_error().$strSQLmember);
			  $rowmember=mysql_fetch_array($resultmember);
			  //echo $rowmember['member_name'];
			  $strSQL = "SELECT a. * , b. * , c. *     
FROM topic a    
LEFT JOIN (    
member b, friend c    
)     
ON a.member_id = b.member_id    
AND a.member_id=c.friend_1  
WHERE   
( a.member_id = '$member_id' )  
OR  
( a.topic_privacy=0 AND c.friend_2='$member_id')   
GROUP BY a.topic_id ";
			  $result = mysql_query($strSQL)or die(mysql_error().$strSQL);
			  
				$Num_Rows = mysql_num_rows($result);
				
				$Per_Page = 10;   // Per Page
				
				$Page = $_GET["Page"];
				if(!$_GET["Page"])
				{
					$Page=1;
				}
				
				$Prev_Page = $Page-1;
				$Next_Page = $Page+1;
				
				$Page_Start = (($Per_Page*$Page)-$Per_Page);
				if($Num_Rows<=$Per_Page)
				{
					$Num_Pages =1;
				}
				else if(($Num_Rows % $Per_Page)==0)
				{
					$Num_Pages =($Num_Rows/$Per_Page) ;
				}
				else
				{
					$Num_Pages =($Num_Rows/$Per_Page)+1;
					$Num_Pages = (int)$Num_Pages;
				}
				
				$strSQL .=" order by a.topic_id DESC LIMIT $Page_Start , $Per_Page ";
				$result  = mysql_query($strSQL);
	  
			  while ($row=mysql_fetch_array($result)){
			  $topic_id = $row['a.topic_id'];
			  //echo $row['topic_name'];			  

			  ?>
              

           
<div class="profile_wall">
<div class="pic_profile">
<?php if($rowmember['member_pic'] == ''){?>
                    <img src="images/bgprofile1.jpg" width="50" height="50" />
                    <?php }else{?>
                    <img src="myfile/<?php echo $rowmember["member_pic"];?>" width="50" height="50" />
                   <?php } ?>


</div>

<div class="text_profile">
<span><label> <?php echo $rowmember['member_name']?></label></span>&nbsp;&nbsp;&nbsp;                    
<span><?php echo $row['topic_date']; ?></span>
<span style="float:right"><form id="form1" name="form1" method="post" action="profile_wall_del_confirm.php?idMem=<?php echo $topic_id;?>">
                         <input name="txttopic_id" type="hidden" value="<?php echo $topic_id; ?>" />
                         <input type="submit" name="Submit" id="button" value="ลบโพสต์" class="btn btn-default"/>
                         </form></span>

</div>
<div class="text_profile2">
<!--<a href="news_feed_comment.php?topic_id=<?php echo $row["topic_id"];?>" style="text-decoration:none" >&nbsp;&nbsp;-->
                      <?php  echo $row['topic_name']; ?>
                      </a> </br>
<span style="float:right"><input type="button" name="button" id="button" value="อ่านรายละเอียดโพสต์" onclick="window.location='news_feed_comment.php?topic_id=<?php echo $row["topic_id"];?>'" class="btn btn-default"/> </span>
</div>
</div>
 

<div>

</div>                       

<?php			  
			  }
			  ?>
			       
 <br>
<!--div button next page--> 
<div style="float:left">

 จำนวน
<?= $Num_Rows;?>
&nbsp;โพสต์
<br />
              
              <!--: หน้าที่ -->
			  <?
			  //$Num_Pages;
			  ?> 
              <?
              if($Prev_Page)
              {
                echo " <span style="float:left"><nav>
  <ul class="pagination">
    <li class="disabled"><a href="$_SERVER[SCRIPT_NAME]?Page=$Prev_Page"><span aria-hidden="true">&laquo;</span><span class="sr-only">Previous</span></a></li>
  </ul>
</nav></span> ";
              }
              
              for($i=1; $i<=$Num_Pages; $i++){
                  $Page1 = $Page-2;
                  $Page2 = $Page+2;
                  if($i != $Page && $i >= $Page1 && $i <= $Page2)
                  {
                      echo "<span style="float:left"><nav>
  <ul class="pagination">
    <li class="disabled"><a href="$_SERVER[SCRIPT_NAME]?Page=$i">$i</a></li>
  </ul>
</nav></span>";
                  }
                  elseif($i==$Page)
                  {
                      echo "<span style="float:left"><nav>
  <ul class="pagination">
    <li class="active"><a href="#">$i<span class="sr-only">(current)</span></a></li>
  </ul>
</nav></span>";
                  }
                                              }
              if($Page!=$Num_Pages)
              {
                  echo "<span style="float:left"><nav>
  <ul class="pagination">
    <li class="disabled"><a href="$_SERVER[SCRIPT_NAME]?Page=$Next_Page"><span aria-hidden="true">&raquo;</span><span class="sr-only">Next</span></a></li>
  </ul>
</nav></span>";
              }
			?>
</div>

</div>

SELECT a. * , b. * , c. *     
FROM topic a    
LEFT JOIN (    
member b, friend c    
)     
ON a.member_id = b.member_id    
AND a.member_id=c.friend_1  
WHERE   
( a.member_id = '$member_id' )  
OR  
( a.topic_privacy=0 AND c.friend_2='$member_id')   
GROUP BY a.topic_id 

SELECT a. * , b. * , c. *     
FROM topic a    
LEFT JOIN (    
member b, friend c    
)     
ON a.member_id = b.member_id    
AND a.member_id=c.friend_1  
WHERE   
a.topic_privacy=0 AND c.friend_2='$member_id'  
GROUP BY a.topic_id