ecshop首页上显示最新评论及评论内容和时间的方法

<?php
if(!function_exists("get_comments")){
function get_comments($num)
{
   $sql = 'SELECT * FROM '. $GLOBALS['ecs']->table('comment') .
' WHERE status = 1 AND parent_id = 0 and comment_type=0 '.
' ORDER BY add_time DESC';
  if ($num > 0)
  {
   $sql .= ' LIMIT ' . $num;
  }
  //echo $sql;
   $res = $GLOBALS['db']->getAll($sql);
  $comments = array();
  foreach ($res AS $idx => $row)
  {
   $comments[$idx]['add_time'] = $comments[$idx]['add_time'] = local_date
($GLOBALS['_CFG']['time_format'], $row['add_time']);
   $comments[$idx]['user_name'] = $row['user_name'];
   $comments[$idx]['content'] = $row['content'];
   $comments[$idx]['id_value'] = $row['id_value'];
  }
  return $comments;
}
}
$GLOBALS['smarty']->assign('my_comments',get_comments(10)); // 10条数据
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!-- 很新评论__Begin -->  <div class="box_2">
   <h3><span>很新评论</span></h3>
  <div class="top10List clearfix">
  <!--{foreach from=$my_comments item=comments}-->
<ul class="clearfix">     <li style="padding:5px 10px;">
 <a href="goods.php?id={$comments.id_value}" target="_blank">
 {$comments.content|truncate:21:""}</a><br />
 {$comments.add_time}
 </li>
 </ul>
  <!--{/foreach}-->
</div>
</div>

</div>
<!--left end-->

<!-- #BeginLibraryItem "/library/index_comments.lbi" -->  <!-- #EndLibraryItem -->