Get the id of the last updated record

activerecord, codeigniter, codeigniter-2, php

Solution

Codeigniter doesn't support that. I had to do this:

$updated_id = 0;

// get the record that you want to update
$this->db->where(array('vrnoa'=>$data['vrnoa'], 'etype' => 'sale'));
$query = $this->db->get('StockMain');

// getting the Id
$result = $query->result_array();
$updated_id = $result[0]['stid'];

// updating the record
$this->db->where(array('vrnoa'=>$data['vrnoa'], 'etype' => 'sale'));
$this->db->update('StockMain',$data);

Problem

I am able to get the last inserted id using `$this->db->insert_id();` in codeigniter, is there any way that I can get the id of the last updated record? I tried it with the same i.e. `$this->db->insert_id();` but it doesn't work (returns 0 instead).

Original source