[eluser]mtbkrdave[/eluser]
Hi Y'all-
This would seem like a pretty silly question, but I can't seem to find a resolution in the manual or forums...
If I want to do multiple database queries in a single function, how do I "clear" the conditions in-between queries?
Code:
$this->db->where('var_1','data_1');
$query1 = $this->db->get('table1');
$this->db->where('var_2','data_2');
$query2 = $this->db->get('table2');
In the example above, how would I prevent the 'var_1' condition from applying to the second query being AND'ed with the second where() statement??
Thanks,
[medic]dave