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

• 목록

상품 구매후기(사용후기) 최근게시글 추출하기


<div style="padding:15px 0 0 0;"><a href="<?php echo $g4['paht'];?>/shop/itemps.all3.php"><img src="/v5/img/main/review_title.jpg" border="0" /></a></div>
<table style="padding-top:20px;" border="0" width="350" cellpadding="0" cellspacing="0">
<?php 
$sql = "select * from ".$g4[yc4_item_ps_table]." where is_confirm = 1  order by is_id desc limit 5 "; 
$result = mysql_query($sql) or die(mysql_error()); 
for($i=0 ; $row=mysql_fetch_array($result); $i++) 
{ 
    $sql2 = " select * from ".$g4[yc4_item_table]." where it_id = '$row[it_id]' "; 
    $row2 = sql_fetch($sql2); 
    $sql3 = " select * from ".$g4[member_table]." where mb_id = '$row[mb_id]' "; 
    $row3 = sql_fetch($sql3); 
    $star = get_star($row[is_score]); 
    echo "<tr><td width='50'><img src='".$g4['path']."/data/item/".$row[it_id]."_s' width='40'>"; 
      
    echo "<td><a href='".$g4['path']."/shop/itemps.all3.php'><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='".$g4['path']."/shop/img".$cart_skin."/star".$star.".gif' border=0></td>"; 
    echo "</tr><tr><td height='1' bgcolor='#cfcfcf' colspan='3'</td></tr>"; 
} 
?></table>