Question

ecshop数据库报错

从ecshop首页点进商品详情页就报这个错MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status FROM `qqq`.`ecs_order_info` AS oi LEFT JOIN `qqq`.`ecs_users` AS u ON oi.user_id = u.user_id, `qqq`.`ecs_order_goods` AS og WHERE oi.order_id = og.order_id AND 1502330716 - oi.add_time < 2592000 AND og.goods_id = $this->_var['id'] ORDER BY oi.add_time DESC LIMIT 5 ) [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 '>_var['id'] ORDER BY oi.add_time DESC LIMIT 5' at line 1 ) [3] => Array ( [errno] => 1064 ) ) ，是什么原因呢？

Answer 1

看错误是数据库查询错误，具体的错误，你可以试着把报错的sql放在数据库下执行，看看到底是什么问题引起的

Answer 2

near '>_var['id'] 这个附近 有错误。 你可以私信给我你的QQ，我可以帮你看看。