Welcome Guest, Not a member yet? Register   Sign In
where_in method unexpected query
#1

Hi,
I have a query like this
Code:
$this->db->where_in('chat_session', $latest_sessions)->update('chat_state', $update_state);

which generating following result

UPDATE `chat_state` SET `status` = 'exit'
WHERE `chat_session` IN('55_6_11,30_6_2')

But I need following query
UPDATE `chat_state` SET `status` = 'exit'
WHERE `chat_session` IN('55_6_11','30_6_2')

I have tried following still not working
Code:
$this->db->where_in('chat_session', $latest_sessions,NULL)->update('chat_state', $update_state);

and

Code:
$this->db->where_in('chat_session', $latest_sessions,FALSE)->update('chat_state', $update_state);
The largest Bengali tutorial site on Web Development in this planet
Reply


Messages In This Thread
where_in method unexpected query - by rejoan - 02-16-2015, 03:50 AM
RE: where_in method unexpected query - by SomeGuy - 02-16-2015, 12:45 PM
RE: where_in method unexpected query - by rejoan - 02-17-2015, 06:41 AM



Theme © iAndrew 2016 - Forum software by © MyBB