Question

急问，ecshop首页搜索页面出现如下错误。

“MySQL server error report:Array( [0] => Array([message] => MySQL Query Error)
[1] => Array([sql] => SELECT cat_name FROM `test`.`hty_category`WHERE
cat_id = )
[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 '' at line 1)[3] => Array([errno] => 1064))”

Answer 1

SELECT cat_name FROM `test`.`hty_category`WHERE
cat_id =

首先你的WHERE前面应该有空格 第二你的cat_id没有值肯定会错误

追问

应该从哪个文件去查找修改呢

追答

你点击了搜索按钮没有 你可以在search.php里面 搜索cat_id 之后找线索