return of a field value (auto-increment) after insert (mysql)

[rjames.clarke@gmail.com]

I am inserting a record in to a mysql database. I'd like to know the
record number of that record.
I use a index field which is auto-incremented.

Is there any way to get a field value returned after insertion?

I have been just running another query for the last record, but if
someone does insertion a split second after the first insertion the
last record would not be the one of interest.

thanks
bobc

[Michael Fesser]

Re: return of a field value (auto-increment) after insert (mysql)

..oO(rjames.cla rke@gmail.com)

>I am inserting a record in to a mysql database. I'd like to know the
>record number of that record.
>I use a index field which is auto-incremented.
>
>Is there any way to get a field value returned after insertion?

http://www.php.net/mysql_insert_id

Micha