SELECT
*
FROM
board_mini_free
where notice = '0' AND secure_mini_list <= 1
ORDER BY
groups desc,seq asc
LIMIT
-5, 20
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 '-5, 20' at line 10 미니홈_포토텍스트형 : 커뮤니티 솔루션 Ver3.2
Unable to connect to database !
1064 <- 오류번호
SELECT
happy_member.*,
Data.update_date,
Data.stats_count,
Data.stats_sum,
Data.stats_point_point,
Data.stats_point_login,
Data.stats_point_board_write,
Data.stats_point_board_reply,
Data.stats_point_board_comment,
Data.stats_point_board_count,
Data.stats_point_board_scrap,
Data.stats_point_board_pick,
Data.stats_point_board_comment_choose
FROM
happy_member AS happy_member
LEFT JOIN
stats_community.happy_member_stats_data AS Data
ON
happy_member.user_id = Data.user_id
AND
Data.display = 'y'
AND
Data.stats_date = '2024-05-00'
WHERE
Data.stats_sum > 0
ORDER BY
Data.stats_sum DESC,
happy_member.number DESC
LIMIT
-5, 3
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 '-5, 3' at line 36 Warning: happy_mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hard/hosting4/community/www/inc/lib_happy_member.php on line 4306