last inserted

[bleak26]

Hi ,this one has been in the back of my mind for ages.
Is there a method to retrive , say the autoincremented value of field of a record, as you insert the record into your mysql database.
thanks guys and girl.

[dreamcatcher]

mysql_insert_id()

[uk2.php.net...]

dc

[coopster]

Not as you enter it in, but right after that you can retrieve the value with LAST_INSERT_ID() [dev.mysql.com].

thanks dc ;-)