Active Record Class

[eluser]Unknown[/eluser]
example1:

Code:

$this->db->where_exp('advert.obj_type =', 3, true, '1');
$this->db->or_where_exp('advert.obj_type IS NULL', null, true, '1');

Code:

WHERE ( `fr_advert`.`obj_type` = 3 OR `fr_advert`.`obj_type` IS NULL )

example2:

Code:

$this->db->where_exp('advert.obj_type =', 3, true, '1');
$this->db->or_where_exp('advert.obj_type IS NULL', null, true, '1');
$this->db->where_exp('advert.balans >', 0, true, '2');
$this->db->or_where_exp('advert.balans IS NULL', null, true, '2');

Code:

( `fr_advert`.`obj_type` = 3 OR `fr_advert`.`obj_type` IS NULL ) AND ( `fr_advert`.`balans` > 0 OR `fr_advert`.`balans` IS NULL )