<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

 <?php

 if(!function_exists("get_comments")){

 function get_comments($num)

 {

    $sql = 'SELECT a.*,b.goods_id,b.goods_thumb,b.goods_name FROM '. $GLOBALS['ecs']->table('comment') .

             ' AS a,'. $GLOBALS['ecs']->table('goods') .'AS b WHERE a.status = 1 AND a.parent_id = 0 and a.comment_type=0 and a.id_value=b.goods_id '.

             ' ORDER BY a.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']       = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);

    $comments[$idx]['content']       = $row['content'];

    $comments[$idx]['id_value']       = $row['id_value'];

    $comments[$idx]['goods_thumb'] = get_image_path($row['goods_id'], $row['goods_thumb'], true);

    $comments[$idx]['goods_name']       = $row['goods_name'];

 }

 return $comments;

 }

 }

 ?>

 <?php

    $this->assign('my_comments',get_comments(8)); // 数据条数

 ?>

 <div>

   <h1> 顾客评论 </h1>

   <div>

     <!-- {foreach from=$my_comments item=comments} -->

     <dl>

       <dt><a href="goods.php?id={$comments.id_value}" target="_blank"><img src="{$comments.goods_thumb}" alt="" /></a></dt>

       <dd><a href="goods.php?id={$comments.id_value}" style="color:#FF6400; font-weight:bold">名称：{$comments.goods_name}</a></dd>

       <dd>{$comments.content|truncate:100:""}</dd>

       <dd>时间：{$comments.add_time}</dd>

     </dl>

     <!-- {/foreach} -->

   </div>

 </div>