plugins - SQL query, error

admin管理员组

文章数量:1433896

I have sql query:

$query= "SELECT * FROM files ORDER BY id DESC LIMIT $from, $site WHERE custom > 0";

but not work, i have notice:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

What i do wrong?

I have sql query:

$query= "SELECT * FROM files ORDER BY id DESC LIMIT $from, $site WHERE custom > 0";

but not work, i have notice:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

What i do wrong?

• plugins
• query
• sql

Share Improve this question edited Jul 21, 2019 at 23:31 Jaron asked Apr 6, 2019 at 21:01 JaronJaron 4588 bronze badges 1

• Order by has to be after where. – Howard E Commented Apr 6, 2019 at 21:16

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 2

You have the where clause of the query in the wrong place.

Your query should be written like this:

$query= "SELECT * FROM files WHERE custom > 0 ORDER BY id DESC LIMIT $from, $site";

As specified here https://dev.mysql/doc/refman/8.0/en/select.html in the MySQL reference.

本文标签： pluginsSQL queryerror