Recall id just allocated to a new record

simonoc

Is it possible to recall the id allocated to the last record as soon as it is posted, I know this sounds rubbish but I want to update the record as soon as it has been posted and don't know how to allocate the updates to an id.

Cheers

nemonoman

MySQL Reference Manual :: 24.2.13.3 How to Get the Unique ID for the Last Inserted Row

http://dev.mysql.com/doc/mysql/en/getting-unique-id.html

thorpe

mysql_insert_id()

simonoc

Thanks that was easy

$x_id = mysql_insert_id();