Question

错误 SQL:

错误

SQL:
SELECT * FROM `ims_article` WHERE weid = '1' AND ORDER BY displayorder DESC, id DESC LIMIT 0,20Params:
array (
)SQL 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 'ORDER BY displayorder DESC, id DESC LIMIT 0,20' at
line 1Traces:
file: /source/class/db.class.php; line: 143;
file: /source/function/pdo.func.php; line: 62;
file: /source/modules/site/model.php; line: 22;
file: /data/tpl/mobile/default/site/detail.tpl.php; line: 36;
file: /source/modules/site/site.php; line: 374;
file: /source/controller/mobile/module.ctrl.php; line: 43;
file: /mobile.php; line: 18;
这是怎么了？怎么解决

Answer 1

and 后面 是什么，怎么直接就 order by了？

AND ORDER BY ？？？

要不把 and 去掉，要不 在 之间 写上 条件判断语句