Finding last insert.

KITTfan2K

Hi.

I have a script that inserts a row into a database, but then I need to find the ID to show to the user (as in, your reference number is: whatever)

Is there an easy way to do this, or do I just need to run a query to find the row where everything matches what the user has entered, then grab that ID number?

I really hope that this makes sense... 🙂

Sxooter

This tends to be database specific. There's a mysql_last_insert_id function, or something similar. In postgresql you need to know the sequence that assigned the serial value, in MSSQL there's @@IDENTITY, I believe.

Generally, you don't want to use some kind of "Select ... order by id desc limit 1" because someone else might have inserted a row between the time you inserted yours and asked for the max row.

KITTfan2K

That's what I was thinking, but I rejected it for the same reason.

What's the syntax for the mysql_last_insert_id function, and what does it do?

btw... I'm using MySQL, if you haven't already guessed!

rincewind456

You could always try the Manual

KITTfan2K

Call me stupid. I was getting confused by the MySQL manual that goes waay over my head.

rincewind456

KITTfan2K wrote:
Call me stupid.

Nah! why would I do that 😉

KITTfan2K wrote:
I was getting confused by the MySQL manual that goes waay over my head.

That manual would confuse anyone, except maybe the guys that wrote it. :eek:

KITTfan2K

Thanks guys...

Now how do I mark the thread resolved??

Sxooter

There's a drop down up top that says "thread tools" and one of the entries is "Mark Thread Resolved"