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?

treeface · Accepted Answer · 2010-11-09 23:52:48Z

73

I think this should do the trick:

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

edited Nov 9, 2010 at 23:52

treeface

13.3k4 gold badges53 silver badges57 bronze badges

answered Nov 9, 2010 at 14:35

JDM

9417 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Refazul · Accepted Answer · 2014-07-14 18:06:51Z

7

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.

answered Jul 14, 2014 at 18:06

Refazul

1091 silver badge5 bronze badges

Comments

Praburam S · Accepted Answer · 2014-06-26 08:10:16Z

5

You Can also Pass a String parameter to where() function like this,

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

answered Jun 26, 2014 at 8:10

Praburam S

1653 silver badges10 bronze badges

Collectives™ on Stack Overflow

Codeigniter Active record: greater than statement

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related