Re: Getting the record just inserted.

[Paul DuBois]

At 5:18 PM -0500 01-31-2000, James Treworgy wrote:
>At 07:00 PM 1/31/00 -0300, Horacio J. Peña wrote:
>>Ah, sorry. I hadn't understood you. Thanks! And, what happens if i do an
>>insert, other process do another insert. When i do that select what do i get?
>
>Hmmmm... I'd guess you need to lock the table before your insert to 
>absolutely ensure data integrity. (TCX?)  See LOCK_TABLES and UNLOCK 
>in the manual.

No, the mysql_insert_id() value (or $dbh->{mysql_insertid} or SELECT
LAST_INSERT_ID() value) is per-client.  Insert activity by other clients
doesn't affect it.

-- 
Paul DuBois, paul@stripped