How to the fetch id of newly created entry

[eluser]pointer[/eluser]

Code:

$this->db->limit(1);
$this->db->from('table');
$this->db->order_by('id', 'desc');
$data['query']=$this->db->get();

or

Code:

$data['query']=$this->db->query("SELECT id FROM table ORDER BY id DESC LIMIT 1");