PHP统计(求和)问题,希望大家可以帮我一下,如果你们愿意就当作生日礼物送给我吧,谢谢!
mysql> select * from article;
+----+----------+----------+------+
| id | title | content | hits |
+----+----------+----------+------+
| 1 | aaaaa | aaaaaaaa | 1 |
| 2 | bbbbb | bbbbbbbb | 2 |
| 3 | ccccc | cccccccc | 3 |
| 4 | ddddd | dddddddd | 4 |
+----+----------+----------+------+
4 rows in set (0.01 sec)
首先祝大家新年快乐!
我现在碰到一个问题,我想计算出上表(article)中的字段hits所有值之和,请问大
家用PHP怎样实现呢?谢谢!
问题点数：100、回复次数：2Top
1 楼yicaoyimu（一草一木）回复于 2003-02-01 11:15:25 得分 20
select count(hits) from article;Top
2 楼nhconch（天蝎蝴蝶）回复于 2003-02-01 11:40:36 得分 80
select sum(hits) as hits from article group by hitsTop
