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

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