PHP代码如何列出每个用户的总价值[关闭]
问题描述：
table A
-----------------
a_id | user |
-----------------
1 |adam |
2 |jose |
3 |adam |
4 |adam |
5 |anne |
6 |jose |
table B
--------------------------------------
b_id | user | value1 | value2
--------------------------------------
1 |adam | 33 | 9
2 |jose | 46 |88
3 |adam | 77 |21
4 |adam | 81 |15
5 |anne | 11 |67
6 |jose | 45 |6
how can I view the total value of value1 and value2.
example: I want my list view page look like this.
--------------------------------------------------------
user | total value of value1 | total value of value2
---------------------------------------------------------
adam |191 | 45
jose |91 | 94
anne |11 | 67
pls. help.
表格A p>
-------- ---------
a_id | 用户|
-----------------
1 | adam |
2 | jose |
3 | adam |
4 | adam |
5 | anne |
6 | jose | \ n code> pre>
表B p>
------------------ --------------------
b_id | 用户| value1 | value2
--------------------------------------
1 | adam | 33 | 9
2 | jose | 46 | 88
3 | adam | 77 | 21
4 | adam | 81 | 15
5 | anne | 11 | 67
6 | jose | 45 | 6
code> pre>
如何查看value1和value2的总值。 p>
示例：我想查看列表视图 页面看起来像这样。 p>
------------------------------- -------------------------
user | value1的总值 value2的总价值
-------------------------------------------- -------------
adam | 191 | 45
jose | 91 | 94
anne | 11 | 67
代码> PRE>
请。 帮助。 p>
div>
答
You could always try some sort of aggregate query such as the following
SELECT user, SUM(value1) AS v1sum FROM B GROUP BY user