ORA-00936:缺少表达式-- codeigniter

Question

我正在尝试从数据库表中获取一些属性的总和，我的代码是：

$get_result=$this->db->query("SELECT 
            SUM(FOUND_SEED_AMOUNT) as FOUND_SEED_AMOUNT,
            SUM(FOUND_SEED_SALE_PRICE) as FOUND_SEED_SALE_PRICE,
            SUM(CHARGE_AMOUNT) as CHARGE_AMOUNT,
            SUM(OTHER_SOU_REC_AMOUNT) as OTHER_SOU_REC_AMOUNT,
            SUM(TOTAL_OBT_AMOUNT) as TOTAL_OBT_AMOUNT,
            SUM(LOCAL_BANK_DEP_AMOUNT) as LOCAL_BANK_DEP_AMOUNT,
            SUM(TRANS_AMOUNT_HEAD_OFFI) as TRANS_AMOUNT_HEAD_OFFI
            FROM SEEDS_RWM_MONT_INCOME WHERE  FISCAL_YEAR=$fiscal_year AND MONTH=$month
            ");

我也尝试过这种方式。

$get_result=$this->db->query(" SELECT 
            SUM(FOUND_SEED_AMOUNT) as FOUND_SEED_AMOUNT,
            SUM(FOUND_SEED_SALE_PRICE) as FOUND_SEED_SALE_PRICE,
            SUM(CHARGE_AMOUNT) as CHARGE_AMOUNT,
            SUM(OTHER_SOU_REC_AMOUNT) as OTHER_SOU_REC_AMOUNT,
            SUM(TOTAL_OBT_AMOUNT) as TOTAL_OBT_AMOUNT,
            SUM(LOCAL_BANK_DEP_AMOUNT) as LOCAL_BANK_DEP_AMOUNT,
            SUM(TRANS_AMOUNT_HEAD_OFFI) as TRANS_AMOUNT_HEAD_OFFI
            FROM SEEDS_RWM_MONT_INCOME WHERE FISCAL_YEAR =". $fiscal_year." AND MONTH = ".$month
            );

但是得到这个错误：

Error Number: 936
ORA-00936: missing expression

查询代码为

SELECT SUM(FOUND_SEED_AMOUNT) as FOUND_SEED_AMOUNT, SUM(FOUND_SEED_SALE_PRICE) as FOUND_SEED_SALE_PRICE, SUM(CHARGE_AMOUNT) as CHARGE_AMOUNT, SUM(OTHER_SOU_REC_AMOUNT) as OTHER_SOU_REC_AMOUNT, SUM(TOTAL_OBT_AMOUNT) as TOTAL_OBT_AMOUNT, SUM(LOCAL_BANK_DEP_AMOUNT) as LOCAL_BANK_DEP_AMOUNT, SUM(TRANS_AMOUNT_HEAD_OFFI) as TRANS_AMOUNT_HEAD_OFFI
FROM SEEDS_RWM_MONT_INCOME
WHERE FISCAL_YEAR =
  AND MONTH =

谁能帮我找出错误！

Answer 1

它就在那里的结尾：

WHERE FISCAL_YEAR =    AND MONTH =
                  ^^^^           ^^^^

看起来您的变量内容是空的，或者替换不起作用

​

​