사용후기 최신글 추출하기

아래 코드를 추가해 보십시오.

<?
$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='./data/item/$row[it_id]_s' width=40>";
     
    echo "<td><b>$row2[it_name]</b><br>
          <a href='$g4[shop_path]/item.php?it_id=$row[it_id]'><font color=#3366cc>".cut_str($row[is_subject],30,"...")."</font></a></td>";
    echo "<td align=right>$row3[mb_name]<br><img src='$cart_skin/star{$star}.gif' border=0></td>";
    echo "</tr><tr><td height=1 bgcolor=#cfcfcf colspan=3</td></tr>";
}
?>