Re: Add a record and recover it's ID in one operation

www.php.net/mysql-insert-id Daniel Page wrote:

Hi, Imagine a table with an auto-increment id number field and a text field for the username. User B (with user name 'johnny') could write to the database a millisecond after user A, with the same username. When user A looks for the last record written by Johnny, A will find the record entered by B. Is there a way to directly recover the auto-incremented number as like a return value (or somthing like that) of the write query as to be able to identify immediately what record you just wrote? This is just for argument's sake - I just would like to know if it is possible. My current solution is inserting the login time of the current user and/or IP, and adding that to make a temporary ID key where you select the latest entry written where username = your username and login time string = hhmmss info so you can immdately find your latest entered data, though recovering immediately the ID would have been a more elegant solution for this. Cheers, Daniel

-- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.