select * from flowers where prod_status='Y' order by prod_id DESC limit -12, 12 1064 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 '-12, 12' at line 1