영카트5 사용후기를 최근게시글로 가져오는 소스


<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>




영카트4 사용후기를 최근게시글로 가져오는 소스

<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>