Omitting where clause for empty criterion

[eluser]cyberjunkie[/eluser]
Thanks ontguy! That put me on the right track For anyone wanting to do this, use the function

Code:

$query = array_filter($your_form_input_array)

and

Code:

$this->db->where($query)

It will omit AND clauses if criteria is empty.