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

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

1 Answer 1

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.