$sql="SELECTSUM(prise)sumfrombuylistwheremid='1'";$ress=mysql_query($sql);echo$rowxiaofei=mysql_fetch_assoc($ress);
$sql="SELECT SUM(prise) sum from buylist where mid = '1'";
$ress=mysql_query($sql);
echo $rowxiaofei=mysql_fetch_assoc($ress);
mysql
求和函数