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 'neill" -()' IN BOOLEAN MODE) AND prods.prod_visible = 1 LIMIT 8' at line 1
SELECT prods.prod_hash, prods.prod_name, CONCAT('£',prods.prod_priceinpence/100) as price, prods.prod_image FROM prods WHERE MATCH(prods.prod_name, prods.prod_brand, prods.prod_promotext, prods.prod_fulldesc) AGAINST ('+"O'neill" -()' IN BOOLEAN MODE) AND prods.prod_visible = 1 LIMIT 8