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 '-6, 6' at line 1 : select * from yp_product where product_status='Active' and product_type='Gel' order by product_id asc limit -6, 6