Codeigniter Active record: greater than statement

Question

I'm trying to convert a "greater than" where statement to CI's Active Record syntax. When I use this snippet

    $this->db->join('product_stocks', "product_stocks.size_id_fk = product_attributes.id", "left");
    $this->db->where('product_stocks.stock_level', '> 1');      
    $result = $this->db->get('product_attributes')->result_array();

Then print $this->db->last_query(); shows WHEREproduct_stocks.stock_level= '> 1' which is of course not correct. Can this be done?

Answer 1

I think this should do the trick:

$this->db->where('product_stocks.stock_level >', '1');  //moved the >

Answer 2

Either

$this->db->where('product_stocks.stock_level >', '1');

or

$this->db->where(array('product_stocks.stock_level >'=>'1'));

should do it. Note the space between the field name and the operator; otherwise you will end up getting Error 1064.