I want to use array in foreach loop but failed, here is my code:
foreach($this->db->get_where('mytable', array('result' => '1 or 2', 'id' => 'foo'))->result_array()
'result' => '1 or 2'piece has a problem but I couldn't find out how can I use array in this kind of foreach.
I want to say
SELECT * WHERE RESULT = 1 OR 2, ID = FOO IN MYTABLE
Thanks in advance.