On 2024-12-22 at 13:39:50, an sql error occured. When asked the trouble, the database said:
"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, 5' at line 1"
The error was thrown from in the function and the offending sql statement is below:
select * from tbl_postjob where 1 and fld_status='1' and fld_city like 'Kota Kinabalu%' order by fld_mod_date desc limit -5, 5