채택완료

특정 게시물만 감추기!

2017-09-26 (화) 16:57:17 2,411

그냥 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 포인트

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개

2017-09-26 (화) 17:25:46
수정없이...바로 작업이 되네요..감사합니다!!!!!!!!

답변을 작성하려면 로그인이 필요합니다.