php - 检索列的几个选定行的总和？

Question

我试图获取数据库中 Money Column 的几行选定行的总和。

sql如下。

$sql_total_money = "SELECT SUM(Money) as TotalMoney FROM accounts WHERE Program='PSC' BranchId='13' and ExamYear='2013'";
$result_total_money=mysql_query($sql_total_money,$link)or die($sql_total_money."<br/><br/>".mysql_error());
$row_total_money=mysql_fetch_array($result_total_money);

由于 die 函数，这会给出如下错误。

SELECT SUM(Money) as TotalMoney FROM accounts WHERE Program='PSC' BranchId='10' and ExamYear='2013'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BranchId='10' and ExamYear='2013'' at line 1

我能做什么，解决方案是什么？

Answer 1

您在 Program='PSC' 之后错过了一个 AND:

SELECT SUM(Money) as TotalMoney
FROM   accounts
WHERE  Program='PSC'
       AND BranchId='10'
       AND ExamYear='2013'