Welcome Guest, Not a member yet? Register   Sign In
Active Record Class

(12-16-2014, 09:30 PM)marci Wrote: 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


Try these:

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


Messages In This Thread
Active Record Class - by marci - 12-16-2014, 09:30 PM
RE: Active Record Class - by apparasenal - 12-16-2014, 10:37 PM

Theme © iAndrew 2016 - Forum software by © MyBB