php - MySQL sum函数报错

问题描述

问 题

我用sql语句求和时出现报错
代码：

$sql_order_fee="select  (goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee from ecs_order_info WHERE user_id=$user_id and pay_status = 2 and TO_DAYS(date_format(from_UNIXTIME(`pay_time `),'%Y-%m-%d'))=TO_DAYS(NOW())";

报错：

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => select sum((goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee) from ecs_order_info WHERE user_id=63 and pay_status = 2 and TO_DAYS(date_format(from_UNIXTIME(`pay_time `),'%Y-%m-%d'))=TO_DAYS(NOW()) ) [2] => Array ( [error] => 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 'AS total_fee) from ecs_order_info WHERE user_id=63 and pay_status = 2 and TO_DAY' at line 1 ) [3] => Array ( [errno] => 1064 ) )

烦请解答一下，我没找到错误原因。

解决方案

括号问题，sum后面多了一个括号，且total_fee后面那个括号是多余

select sum(goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee from ecs_order_info WHERE user_id=63 and pay_status = 2 and TO_DAYS(date_format(from_UNIXTIME(`pay_time `),'%Y-%m-%d'))=TO_DAYS(NOW())

这篇关于php - MySQL sum函数报错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！