그냥 sql로 뿌리고있는데..
특정 게시물을 상단에 고정하다보니
이미 와일문에 돌고있는 게시물이 한번더 중복되드라구요
중복된것을 감추려고합니다 ㅠㅠ
wr_id =6 하고 wr_id=8번이요..ㅠㅠ
가능할까요..ㅠㅠ
코드는 아래 상황입니다.
Copy
<!-- 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개 / 댓글 1개
채택된 답변
+20 포인트
2017-09-26 (화) 17:02:32
35 라인에서
Copy
$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";
하시면 안나옵니다.
답변에 대한 댓글 1개
답변을 작성하려면 로그인이 필요합니다.