특정 게시물만 감추기!
본문
그냥 sql로 뿌리고있는데..
특정 게시물을 상단에 고정하다보니
이미 와일문에 돌고있는 게시물이 한번더 중복되드라구요
중복된것을 감추려고합니다 ㅠㅠ
wr_id =6 하고 wr_id=8번이요..ㅠㅠ
가능할까요..ㅠㅠ
코드는 아래 상황입니다.
<!-- Contact Section -->
<div id="contact" class="page">
<div class="container">
<!-- Title Page -->
<div class="row">
<div class="span12">
<div class="title-page">
<!-- <h2><img width="100%" src="./images/review_title.png" alt="" /></h2> -->
<table style="margin:0 auto">
<td valign="top">
<a href="review_view.html?bo_table=new_review_movie&wr_id=6">
<img src="../data/file/new_review_movie/2948935394_cWSiClnH_review_4.png" style=" width:130px;height:150px" alt="">
</a>
</td>
<td valign="top">
<a href="review_view.html?bo_table=new_review_movie&wr_id=8">
<img src="../data/file/new_review_movie/2948935394_b5m2Erix_review_6.png" style=" width:130px;height:150px" alt="">
</a>
</td>
<td height="20" colspan="4"></td>
<tr>
<?
$tname = "g4_write_new_review_movie";
$bo_table = "new_review_movie";
//$tname = "g4_write_new_pt_m_gallery";
//$bo_table = "new_review_gallery";
$num_per_page = 10;
$tr_Repeat = $num_per_page/5;
$cntRcd = Board_countRecord($db, $tname, $key, $keystring, $num_per_page, $page, $category);
$Qstring = "SELECT * from $tname where wr_id!='' order by wr_id desc limit $cntRcd[0],$num_per_page";
$res = $db->Query($Qstring);
while($row = mysql_fetch_array($res)){
$text = strip_tags($row[wr_content]);
$sql = "select * from g4_board_file where bo_table = '$bo_table' and wr_id = '$row[wr_id]' order by bf_no";
$Mrow = $db->aQuery($sql);
?>
<td width="50%" align="left" style="padding:5px"><table style="background:#fff;">
<? if($Mrow[bf_file]){ ?>
<tr>
<td valign="top"><a href="review_view.html?bo_table=<?=$bo_table?>&wr_id=<?=$row[wr_id]?>"><img src="../data/file/<?=$bo_table?>/<?=$Mrow[bf_file]?>" style=" width:130px;height:150px" alt=""></a></td>
</tr>
<?}else{?>
<tr>
<td valign="top"><a href="review_view.html?bo_table=<?=$bo_table?>&wr_id=<?=$row[wr_id]?>"><img src="/skin/board/webzine/img/noimage.gif" style="width:100%; height:150px" alt=""></a></td>
</tr>
<?}?>
<!-- <tr>
<td style="font-size:13px; padding:5px; color:#222; line-height:20px;"><b><?=strcut_utf8($row[wr_subject], 12)?></b></td>
</tr> -->
<!-- <tr>
<td height="40" valign="top" style="font-size:13px; padding-left:5px; padding-right:5px; padding-bottom:5px; line-height:19px;"><?=strcut_utf8(strip_tags($text), 25);?></td>
</tr> -->
</table></td>
<?
$cntTr++;
if(($cntTr%$tr_Repeat) == 0){
echo '
</tr>
<tr>
<td height="20" colspan="4"></td>
</tr>
';
}
}
?>
</tr>
<tr class="paging">
<td align="center" colspan="3"><?=Board_pageNumber($cntRcd[3], $page_per_block, $page, $tname, $bbs_skin, $key, $keystring, $category);?></td>
</tr>
</table>
</div>
</div>
</div>
<!-- End Title Page -->
</div>
</div>
<script type="text/javascript">
$(function(){
$(".paging a span").css({"color":"#999", "border-color":"#999"})
})
</script>
<!-- End Contact Section -->
답변 1
35 라인에서
$Qstring = "SELECT * from $tname where wr_id!='' and wr_id not in('6','8') order by wr_id desc limit $cntRcd[0],$num_per_page";
하시면 안나옵니다.
수정없이...바로 작업이 되네요..감사합니다!!!!!!!!
답변을 작성하시기 전에 로그인 해주세요.
