[YC5] 상품 구매후기(사용후기) 최근게시글 > 기술자료

• 목록

사용후기를 최근게시글로 가져오는 소스입니다.



<div style="padding:15px 0 0 0;"><a href="<?php echo G5_SHOP_URL; ?>/itemuselist.php"><img src="/v5/img/review_title.jpg" border="0" /></a></div>
<script src="<?php echo G5_JS_URL; ?>/viewimageresize.js"></script>
<table style="padding-top:13px;" border="0" width="350" cellpadding="0" cellspacing="0">
    <?php
    $sql = "select * from ".$g5[g5_shop_item_use_table]." where is_confirm = 1  order by is_id desc limit 6 "; 
    $result = sql_query($sql) or die(sql_error()); 
    for($i=0 ; $row=sql_fetch_array($result); $i++) 
    { 
        $sql2 = " select * from ".$g5[g5_shop_item_table]." where it_id = '".$row[it_id]."' "; 
        $row2 = sql_fetch($sql2); 
        $sql3 = " select * from ".$g5[member_table]." where mb_id = '".$row[mb_id]."' "; 
        $row3 = sql_fetch($sql3); 
        $star = get_star($row[is_score]); 
        $it_href = G5_SHOP_URL."/item.php?it_id=".$row['it_id']."";
        $is_content = get_view_thumbnail(conv_content($row['is_content'], 1), $thumbnail_width);
        echo "<tr><td width='50'><a href='".$it_href."'>".get_itemuselist_thumbnail($row['it_id'], $row['is_content'], 50, 50)."</td>"; 
          
        echo "<td style='padding-left:7px;'><a href='".$it_href."'><b>".$row2[it_name]."</b><br> 
              <font color=#3366cc>".cut_str($row[is_subject],30,"...")."</font></a></td>"; 
        echo "<td align=right>".$row3[mb_name]."<br><img src='shop/img".$cart_skin."/s_star".$star.".png'></td>"; 
        echo "</tr><tr><td height='1' bgcolor='#cfcfcf' colspan='3'</td></tr>"; 
    }
    ?>
</table>