Maybe you have autocommit on or something weird? From the MySQL documentation ( version 5.5), LAST_INSERT_ID() is per-connection, so it should be valid for each of your clients.

• https://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_last-insert-id
• https://dba.stackexchange.com/questions/21181/is-mysqls-last-insert-id-function-guaranteed-to-be-correct
• https://dba.stackexchange.com/questions/31346/does-last-insert-id-returns-correct-result-when-writes-from-multiple-sessions

As a stylistic note, calling your error handler as &ErrorDBI; may or may not be what you want. Your method of calling it passes it the current contents of @_. The more explicit way of calling a function is:

ErrorDBI();
[download]

Also, I would set $dbh->{RaiseError} to 1, just to be sure that all database errors are fatal.

Comment on Re: SELECT LAST_INSERT_ID does not work Select or Download Code