Easy SQL query

[eluser]JoostV[/eluser]
You probably tried this already, but $this->db->insert_id() merely returns the id, so
a. you need to have inserted a record first, or $this->db->insert_id() will not return anything
b. you need to capture the insert id in order to be able to do anything with it.

Code:

// Insert a record
$this->db->insert('mytable', $data);

// Retrieve last inserted id
$id = $this->db->insert_id();

// Print the last inserted id to screen
var_dump($id);