вопрос
Собственно, где-то кроется ошибка в этом запросе:
Буду благодарен, если кто-то сможет помочь устранить.
$db->query("SELECT * FROM " . USERPREFIX . "_users WHERE repa > '0' AND repa_off = '0' ORDER by repa DESC LIMIT 0,".$limit."");
MySQL error in file: /engine/modules/repa-top.php at line 34
Error Number: 1064
The Error returned was:
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 '' at line 1
SQL query:
SELECT * FROM dle_users WHERE repa > '0' AND repa_off = '0' ORDER by repa DESC LIMIT 0,
Error Number: 1064
The Error returned was:
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 '' at line 1
SQL query:
SELECT * FROM dle_users WHERE repa > '0' AND repa_off = '0' ORDER by repa DESC LIMIT 0,
Буду благодарен, если кто-то сможет помочь устранить.
Не задано значение переменной $limit
$limit = 10;
$db->query("SELECT * FROM " . USERPREFIX . "_users WHERE repa > '0' AND repa_off = '0' ORDER by repa DESC LIMIT 0,".$limit);