Select AND / OR problem

[eluser]xwero[/eluser]
[quote author="Khoa" date="1220008127"]xwero, your method is a way to work around this, but by doing so, I think we cannot make use of the escaping feature that CI provides (well, to be honest, I dont really know what CI does, but feel more confident whey it says it does :-D). Am i right?[/quote]
You can escape the values but you have to do it yourself

Code:

$escaped_product1 = $this->db->escape($product1);
$escaped_product2 = $this->db->escape($product2);
$query = $this->db->select('productID')->from('product')->where('(`productName` LIKE ‘'.$escaped_product1.' %’ OR `productName` LIKE ‘% '.$escaped_product1.' %’ OR `productName` LIKE ‘% '.$escaped_product1.'’)
AND (`productName` LIKE ‘'.$escaped_product2.' %’ OR `productName` LIKE ‘% '.$escaped_product2.' %’ OR `productName` LIKE ‘% '.$escaped_product2.'’)')->get();