getting last insert id

[eluser]Unknown[/eluser]
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.