how to recieve an ID when INSERT a new record ??

[eluser]satanrulehis[/eluser]
Hi all!!
I insert a record to a table in database, and I want to get its ID after insert? , how to make a SQL or any idea?
Thanks all for reading and help

[eluser]pistolPete[/eluser]
User guide:

Code:

$this->db->insert_id()

The insert ID number when performing database inserts

[eluser]satanrulehis[/eluser]
Thanks, i got it