SELECT * FROM sexshop WHERE 1=1 AND ProductCategory='Lingerie/Costumes/1' AND (Omschrijving LIKE '%XL%' OR Productnaam LIKE '%XL%' OR prijs LIKE '%XL%' OR ProductURL LIKE '%XL%') LIMIT -10, 10 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 '-10, 10' at line 1