get insert id - SOLVED - this->db->insert_id()

[eluser]mikemike[/eluser]
I don't think it works that way, I'm pretty sure it's linked to the DB connection resource.

So, in theory, you could make an insert at the top of your code, then have the page do something time consuming for 10 minutes and call the function at the bottom of the page. No matter if someone else inserted something in the mean time, the value of the function would be the same, because it's the last inserted ID of that connection.

In the years I've spent doing this stuff, I've never once had any issues with inserted id's - and I've worked on site with many hundreds of thousands of unique visits a day.