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.com/doc/refman/8.0/en/select.html in the MySQL reference.