ID of auto-incremented Row after INSERT

[aaron_karp]

I think this is a pretty simple problem, but I can't find the solution anywhere.

I've just inserted a new row into my table, and this table has an auto-incremented column / primary key called ID. Is there a quick php/mysql combo that will retreive the ID of my most recent INSERT? This is the only field in the table guaranteed to be unique. Thanks!

[csn]

You can use MAX(ID). I can't remember off-hand if mysql has auto-increment related functions.

[aaron_karp]

Thanks, that would work, but this is for a relatively large system, with many many queries running at once, and I don't want to run the risk of grabbing the wrong ID. Any other thoughts?

[Sxooter]

There's a mysql specific function called something like mysql_lastinsert_id or something.

[aaron_karp]

mysql_insert_id - that's it - thanks

[csn]

Oh, duh - my bad - just use PHP's mysql_insert_id(). It's safe from race conditions.