help, updating excisting row in database[SOLVED]

[eluser]danmontgomery[/eluser]

Code:

$id['ID_Page'] = $sql;

This shouldn't be an array... Furthermore, you can't pass a database result to where() (or any of the active record functions, for that matter). It would just be easier to limit and order your update query:

Code:

$this->db->order_by('ID_Page', 'DESC')->limit(1)->update($table_name, array('field_to_update' => 'new_value'));