Showing inactive products using where('status','active');

[eluser]czetsuya[/eluser]
Hi,

This is because of the active class functions that you have used:

Code:

$this->db->like('name',db_clean($term));
$this->db->or_like('shortdesc',db_clean($term));
$this->db->or_like('longdesc',db_clean($term));
$this->db->where('status','active');

//that statements produced
//WHERE name LIKE '%$term%' OR shortdesc LIKE '%$term%' OR longdesc LIKE '%$term%' AND status='active'

Note the OR.

Try this:

Code:

$this->db->where("(name LIKE '%$term%' OR shortdesc LIKE '%$term%' OR longdesc LIKE '%$term%') AND status='active'")

Take note of the parenthesis ( )

Regards,
czetsuya