CodeIgniter Forums

Full Version: active record problem (and/or)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

hi, i'm new here and i have a proble using active record for a search function using like
my code:
function get_main_search()
        $keyword = $this->uri->segment(3, 0);
        $this->db->like('itemName', $keyword);
        $this->db->where('instock <>', '9');
        $this->db->or_like('label', $keyword);
        $this->db->where('instock <>', '9');
        $this->db->or_like('labelname', $keyword);
        $this->db->where('instock <>', '9');
        $this->db->or_like('title', $keyword);
        $this->db->where('instock <>', '9');
        $this->db->orderby('itemName, title');
        $query = $this->db->get('items');
        return $query;
it seems to ignore the instock <> 9 part of the query. this works when use a normal sql query instead of active class. am i missing something?

thanks for your time

El Forum

Try and write the same query using standard sql, and see if you get the same result. If you do then its something to do with your logic. When i get these problems i break it down and start simple and gradually add the "ands" and compare the results until i find the piece that is breaking the query.