LAST_INSERT_ID( )

[ChrisSkidmore]

Hi,

My basic question is . "is LAST_INSERT_ID( ) a value returned everytime an insert query is run?"

Why?
Inserting into two tables: The second insert contains the auto_increment value from the first.

I have two users on line. User X clicks the button to send the form which is saved in the database.
Before the server has parsed the next line of code containing my 2nd insert query with LAST_INSERT_ID( ) user Y sends his form updating the auto_increment field.

I suspect I'm ok here and it would only return the last_user_id for a specific connection but I'd be grateful if you could confirm this so I can sleep easy tonight!!

Chris

[pootergeist]

yup - you'd be fine.

the mysql_insert_id would only reference the auto_inc field of the record that was inserted for the script in question - it wouldn't even know about the second person doing the same.

[ChrisSkidmore]

thank you!