multiple where stmts how to use in pagination

[eluser]sunshine[/eluser]
Is there any way by which we can have multiple where clauses use OR instead of AND?

[eluser]mdavis1982[/eluser]
Hi...

Yeah... you can have multiple WHERE clauses... just do:

Code:

$this->db->where('name', $name);
$this->db->where('title', $title);
$this->db->where('status', $status);

If you need OR instead of and, use or_where():

Code:

$this->db->where('name', $name);
$this->db->or_where('id, $id);

Hope this helps...

Matt

[eluser]sunshine[/eluser]
Hey thanx Matt, it worked!!!

[eluser]mdavis1982[/eluser]
No problem.

It's all in the user guide! ;-)

Cheers...

Matt