I am using $this->db->query() function to execute insert query(classical style).At this time if i am using $this->db->insert_id() function to retrive last insert id.But that function always returns 0 instead of last insert id.I am using mysql db.So please guide me or provide function to get last insert id with classical style.

You can use the MySQL function mysql_insert_id()

CodeIgniter also has the very helpful $this->db->insert_id();

@Michael: Tut tut tut, didn’t read the thread properly

ganno - 10 May 2009 01:45 PM

At this time if i am using $this->db->insert_id() function to retrive last insert id.But that function always returns 0 instead of last insert id.

(Sorry, had to be said )

Whoops - nice catch! I am curious as to why the function is returning 0 everytime…

Without ooking at its implementation, these are onlky guesses
- There is no auto incrementing ID
- Its a multipart primary key (but this function can only return a single value)
- There may be more then one unique fields in the table

@Ganno: Does this happen with all your tables, or just one? Whats the schema for your table?