SELECT * FROM sexshop WHERE 1=1 AND ProductCategory='Lingerie/1' AND (Omschrijving LIKE '%L%' OR Productnaam LIKE '%L%' OR prijs LIKE '%L%' OR ProductURL LIKE '%L%') 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