Question

我正在开发一个需要这样做的制度:

I have various rows on one table, and one of them is Total
I want the script that can add the total of all the fields in the Total column.
I will then add the session user so that it only calculates all total fields in that column for that particular person.

请让我问: 查询单例为30天

$query="SELECT * 
          FROM clientdata 
         WHERE ADDTime BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW() 
           AND member_id= " . $_SESSION[ SESS_FIRST_NAME ] . " ";

因此,你还可以在本届会议上增加以下员额的守则细节。

Answer 1

我不知道我是否正确,但我认为你希望这样做。

select sum(total) WHERE ADDTime BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW() AND member_id= " . $_SESSION[ SESS_FIRST_NAME ] . " ";

Answer 2

利用MySQLs SUM(功能:

$query="SELECT SUM(total), * FROM clientdata WHERE ADDTime BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW() AND member_id= " . $_SESSION[ SESS_FIRST_NAME ] . " ";

仅使用<代码>,* 查询范围,如果你想要/要求提供更多数据。

Answer 3

你的提问是明确的,你没有提供你的桌子布,但当你说“一栏中所有领域的总和”时,你就会有一个这样的表格:

id | field1 | field2 | field3 | ... | Total | UserID

并且希望<代码>Total 栏到平等field1 + Field2 + field3 + ? 或者说,你们有一些东西:

id | Type     | Value | UserID
1  |  field1  |  ...  |  ..
2  |  field2  |  ...  |  ..
3  |  field3  |  ...  |  ..
4  |  Total   |  ...  |  ..

第一个问题是:

SELECT UserID, SUM(field1 + field2 + field3 + ...) AS Total
FROM table
GROUP BY UserID

第二部分:

SELECT UserID, SUM(Value) AS Total
FROM table
GROUP BY  UserID ,  Type 
WHERE ( Field  <>  Total )

......或也许我会完全误解你的问题。

友情链接