Answer by Mitchell McKenna for CodeIgniter Active Record, basic update give error
September 29 2010, 5:51am
Curious, see if it works when you escape the string use $this->db->escape()
$data = array('adr' => $this->db->escape($address)); $this->db->where('id', $id); $this->db->update('domains', $data);