영카트 [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>
<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>
댓글목록
등록된 댓글이 없습니다.