自己构造sql语句 [ 新手入门 ]

$sql="select sum(score) as sum_score,count(score) as count_score from oa_score where eid=:eid and score_weight=:score_weight and cid=:cid and standard_id=:standard_id";
$results=$db->createCommand($sql)->query(	array(":score_weight"=>$item_weight['pid_weight'],":cid"=>$key,":standard_id"=>$item->id,":eid"=>$id )
); 
foreach($results as $score){
    $porportion_score=Standard::model()->findByPk($item->id)->porportion; //每项标准的比例值
    $sum+=$score["sum_score"]*$porportion_score/100;					   
}

这是我自己找的 分享给菜鸟吗 因为我也是菜鸟 自己学东西太难了 不管有没有用 我留下了 高手们别笑话我啊