Benim sorunumu analiz ettikten sonra, ancak ben emin değilim, ben SQL "sendika" operatörünü kullanmanız gerekebilir düşünüyorum. Anywho Ben bu sorgu ile çıkıp CodeIgniter'daki benim sorguları zincirleme ediyorum:

SELECT *
FROM (`deals`)
WHERE `category` = 'books'
AND `host` = 'amazon'
OR `host` = 'zappos'
OR `host` = 'newegg'
ORDER BY `time` desc 

So it selects things that aren't in the category books, but are from those hosts. So I'm looking to make it so it returns only results in books, AND have a host of any of those three. I would prefer doing this with a database query rather than manually filtering afterwards. I am using MySQL with an innoDB table. Thanks