Welcome Guest, Not a member yet? Register   Sign In
a problem with get_where
#1

[eluser]edhrx[/eluser]
Hi
this code
$query = $this->db->get_where('mem_sys_views', array('mode' => $mode,
'action' => $action));

Gives me this
Error Number: 1054

Unknown column 'form_id' in 'where clause'

SELECT * FROM (`mem_sys_views`) WHERE `form_id` = 'bfcebbbd76ff508773d7a974e308bae5' AND `mode` = 'member' AND `action` = 'edit'
Note form_id is not in the 'where' array

I'm guessing (at the moment)it comes from a previous call to where() or get_where()
Do I somehow need to 'clear' the where clause before creating another

I'm on the latest version of CI

best wishe Ed


Messages In This Thread
a problem with get_where - by El Forum - 03-26-2008, 03:33 AM
a problem with get_where - by El Forum - 03-26-2008, 03:42 AM
a problem with get_where - by El Forum - 03-26-2008, 03:42 AM
a problem with get_where - by El Forum - 03-26-2008, 04:39 AM
a problem with get_where - by El Forum - 04-02-2008, 01:15 PM
a problem with get_where - by El Forum - 04-02-2008, 03:51 PM



Theme © iAndrew 2016 - Forum software by © MyBB