How to determine next record ID.

Anon

I am writing a php script that maintains a table in a database. The index to the table is an id field that I have defined as auto-increment. I need to be able to determine what id will be assigned prior to the record being added or be able to quickly determine the id that was added so that I can use it can be used in the calculations that immediately follow the add. Any ideas?
Thanks for your help.

Anon

Check the function mysql_insert_id. It will retrieve the id of the last insert.
Just be sure to call it right after the insert! Or send both queries in one.

Still i don't call this method 100% reliable.

Anon

This if you're using MySQL as database of course. 🙂

Anon

Still i don't call this method 100% reliable.

Of course it's completely reliable. Do you actually have an actual documented instance where an insert followed immediately by mysql_insert_id() gave you a different value? Sure, MySQL has lots of limitations, but this is not one of them.

Anon

Would one need be concerned using this method if the possibility existed that two or more people might be accessing the page at the same time. So then you might read the latest id so that you would know the next id then someone else might write back to the database and take the next id. I'm I making any sense?

Anon

No concern at all. The last-id-used is maintained on a per-connection basis.