Active Record Class

Until recently, I've always been able to use the Active Record class to access my databases. Now I have a query with a WHERE clause that looks like this: WHERE item = 1 AND (description LIKE '%keyword%' OR name LIKE '%keyword%'). I'm curious how I would use the where and like functions in the Active Record class to create this clause.
Thanks, Marci

Until recently, I've always been able to use the Active Record class to access my databases.  Now I have a query with a WHERE clause that looks like this:  WHERE item = 1 AND (description LIKE '%keyword%' OR name LIKE '%keyword%').  I'm curious how I would use the where and like functions in the Active Record class to create this clause.
Thanks, Marci

Hi,

Try these:

$this->db->where('item', 1);
$this->db->like('description', $keyword);
$this->db->or_like('name', $keyword);

Proprietor and Developer:

http://app-arsenal.com
http://senhosting.com