mysql求和函数使用示例

代码如下:

$sql="SELECT SUM(prise) sum from buylist where mid = '1'"; 
$ress=mysql_query($sql); 
echo $rowxiaofei=mysql_fetch_assoc($ress);