상품 리스트출력에 where 절 추가하려면 채택완료

</strong><?php
if (!defined('_GNUBOARD_')) exit; // 개별 페이지 접근 불가</p><p>// add_stylesheet('css 구문', 출력순서); 숫자가 작을 수록 먼저 출력됨
add_stylesheet('<link rel="stylesheet" href="'.G5_SHOP_CSS_URL.'/style.css">', 0);</p><p> </p><p>?></p><p><script type="text/javascript"> 
$(document).ready( 
function() { 
$.each($('.tr_arr:odd'), function(i){ // 홀수 번째 
$(this).css("backgroundColor", "#F7F7F7"); 
}); 
$.each($('.tr_arr:even'), function(i){ //짝수 번째 
$(this).css("backgroundColor", "#FFFFFF"); 
}); 
}); </p><p> </p><p>$(function(){
 $('.forRowspan').each(function() {
  var table = this;
  $.each([1] , function(c, v) {
   var tds = $('>tbody>tr>td:nth-child(' + v + ')', table).toArray(), i = 0, j = 0;
   for(j = 1; j < tds.length; j ++) {
    if(tds[i].innerHTML != tds[j].innerHTML) {
     $(tds[i]).attr('rowspan', j - i);
     i = j;
     continue;
    }
    $(tds[j]).hide();
   }
   j --;
   if(tds[i].innerHTML == tds[j].innerHTML) {
    $(tds[i]).attr('rowspan', j - i + 1);
   }
  });
 });
});</p><p></script> </p><p>
  
<div style="width: 1000px;  border-top: 0px solid #DEDEDE; border-bottom: 2px solid #DEDEDE;"></p><p>  <table  cellpadding="0" cellspacing="1" border="0" style="width:1000px; background-color:#CCC" class="forRowspan">
  </p><p>    <?php for ($i=0; $row=sql_fetch_array($result); $i++) { 
 
    // 상품품절체크
  $is_soldout = is_soldout($row['it_id']);</p><p>  // 주문가능체크
  $is_orderable = true;
    if(!$row['it_use'] || $row['it_tel_inq'] || $is_soldout)
        $is_orderable = false;
  
   ?></p><p> 
 
<a href=""></a></p><p>     <tr class="tr_arr"> 
   </p><p>            <td width="350px" style="padding:4px 10px; line-height:180%" onClick="window.open('<?php echo G5_SHOP_URL; ?>/item_popup.php?it_id=<?php echo $row['it_id'] ?>','mailform','width=600, height=520, toolbar=no, menubar=no, scrollbars=yes, resizable=yes');">  
<span style="font-size:14px"><? echo $row['it_name'] ?></span>   <img src = "../img/course/info_kangja.jpg" align="absmiddle"></p><p>

<span style="color:#666; font-size:14px">
     <?php if($row['it_basic'])
  {
   echo conv_content($row['it_basic'], $html); 
  }  
   ?>
</span>
</td></p><p>
 <td width="200px" style="padding:4px 10px">
        
          
        
        
        <span style="font-size:13px">
  <? 
  $time = strtotime($row['it_5']);
  $data_print=date("a g:i ",$time);
  echo $data_print; ?>~<? 
  $time2 = strtotime($row['it_6']);
        $data_print2=date("g:i ",$time2);
  echo $data_print2; ?></span>  
        
        
        
        </td>
  <td width="420px" style="padding:4px 10px">
        <span style="font-size:13px">            
  <?php 
        $sql2 = "select * from `teacher` where `it_id` = '{$row['it_id']}'";
  $result2 = sql_query($sql2, false);
         for ($i=0; $row2=sql_fetch_array($result2); $i++) { 
  ?> 
   <b><?php echo $row2['wr_session']; ?></b> <?php echo $row2['wr_teacher']; ?>  
  <? } ?>     
        </span></td>
  <td width="100px" style="padding:4px 10px" align="center">
       <?php  if($row['it_11'] == '신청'){ ?>
        <a href="<?php echo G5_SHOP_URL; ?>/item.php?it_id=<?php echo $row['it_id'] ?>" class="sct_a"><img src = "../img/bbs/btn_B.gif" align="absmiddle"></a>
  <?php } elseif($row['it_11'] == '임박'){ ?>    
        <a href="<?php echo G5_SHOP_URL; ?>/item.php?it_id=<?php echo $row['it_id'] ?>" class="sct_a"><img src = "../img/bbs/btn_ending.gif" align="absmiddle"></a>
        <?php } elseif($row['it_11'] == '마감'){ ?>    
        <img src = "../img/bbs/btn_end.gif" align="absmiddle">
        <?php } elseif($row['it_11'] == '대기중'){ ?>    
        <a href="#" onClick="window.open('../formmail/form_reservation.html','mailform','width=580, height=520, toolbar=no, menubar=no, scrollbars=no, resizable=yes');return false;"><img src = "../img/bbs/btn_k2.gif" align="absmiddle"></a>        
     <?php } ?>    </p><p>        </td>
 </tr>
  
    </p><p><? } ?></p><p>    </table></p><p>
</div> <strong>