SQL查询在更改php文件名称后不从两个表中添加值


SQL query not adding values from two tables after changing name of php file

我已经编写了一个SQL查询,可以完美地,它按照预期做了所有事情,但是当我更改PHP文件的名称时,出于某种原因,我停止获得正确的输出。我没有改变查询中的一行,也不能为我的生活弄清楚我做了什么不同,除了改变PHP文件的名称。

下面是查询:

"SELECT ua.Username, t.Name as tariffs, ec.ElecEnergy, ua.Username as User, b.AccountBalance as UserBalance, d.Discount as DiscountUser, 
    b.VAT as UserBalance, c.ElecCharge, c.DueDate as date,
    SUM(ec.ElecEnergy) as gg,
    SUM(c.ElecCharge) as cc
FROM useraccount ua INNER JOIN
     tariff t
     ON ua.tariffs = t.id INNER JOIN
     energyconsumption ec
     ON ec.User = ua.id INNER JOIN
     balance b 
     ON b.UserBalance = ua.id INNER JOIN
     discount d 
     ON d.DiscountUser = ua.id INNER JOIN
     charge c
     ON ec.ChargeID = c.id
WHERE c.Date  = CURRENT_DATE
GROUP BY ua.Username, t.Name, c.DueDate";
如果有人能帮我解决这个问题,我将非常感激!

提前感谢!

编辑:这是我得到的当前输出:

{"results":[{"Username":"absc868","TariffName":"s1","ElecConsump":"1900","AccountBalance":"5","Discount":"0.05","VAT":"5","ElecCharge":"266.26","DueDate":"2016-11-30"}]}
我应该得到的是:
{"results":[{"Username":"absc868","TariffName":"s1","ElecConsump":**"3900"**,"AccountBalance":"5","Discount":"0.05","VAT":"5","ElecCharge":**"546.26**","DueDate":"2016-11-30"}]}

问题已解决原来我的WHERE语句有一个问题。我过滤的是电荷表中的日期,而实际上我应该过滤的是能耗表中的日期。

向所有人道歉。愚蠢的小错误。