Hi!
I like to know how to retrieve the record id after an "insert into" query.
I have the table "user" containing two columns: UID (auto_increment) and
USERNAME. After I have added a new user (using "insert into user (uid)
....etc.) I like to know the UID of the new record.
I can set the record pointer to the last record, but if anybody else also
inserts a record at the same time, I think this will give a problem.
Can anybody give me a suggestion?
thanks in advance,
Viktor v/d Berg
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php