I seem to be having difficulties when using the following query:
$query = mysql_query("SELECT * FROM `products` WHERE `name` RLIKE '%$s1%' OR `name` RLIKE '%$s2%' OR `name` RLIKE '%$s3%' OR `name` RLIKE '%$s4%' OR `description` RLIKE '%$s1%' OR `description` RLIKE '%$s2%' OR `description` RLIKE '%$s3%' OR `description` RLIKE '%$s4%' OR `inci` RLIKE '%$s1%' OR `inci` RLIKE '%$s2%' OR `inci` RLIKE '%$s3%' OR `inci` RLIKE '%$s4%' OR `functions` RLIKE '%$s1%' OR `functions` RLIKE '%$s2%' OR `functions` RLIKE '%$s3%' OR `functions` RLIKE '%$s4%' OR `supplier` RLIKE '%$s1%' OR `supplier` RLIKE '%$s2%' OR `supplier` RLIKE '%$s3%' OR `supplier` RLIKE '%$s4%'");
Any clues as to why?
It doesn't return any values what so ever.
Cheers and any help appreciated.
Scaasiboi