My basic question is . "is LAST_INSERT_ID( ) a value returned everytime an insert query is run?"
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!!