ecshop首页商品显示已评论数量

function get_evaluation_sum($goods_id)
{
$sql = "SELECT count(*) FROM " . $GLOBALS['ecs']->table('comment') . " WHERE status=1 and  comment_type =0 and id_value =".$goods_id ;//status=1表示通过了的评论才算  comment_type =0表示针对商品的评价
return $GLOBALS['db']->getOne($sql);
}

$goods[$idx]['url'] = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);

$goods[$idx]['evaluation'] = get_evaluation_sum($row['goods_id']);

$goods[$idx]['url'] = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);

$goods[$idx]['evaluation']   = get_evaluation_sum($row['goods_id']);