我有sql查询：
$query= "SELECT * FROM files ORDER BY id DESC LIMIT $from, $site WHERE custom > 0";
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax
SQL query, error
1 个回复
最合适的回答,由SO网友:Howard E 整理而成
你有where 查询的子句位于错误的位置。
您的查询应该这样写：
$query= "SELECT *
FROM files
WHERE custom > 0
ORDER BY id DESC
LIMIT $from, $site";