Pull the Last Record Functionality?

[PHPRookie]

I have built a wonderful web experience using PHP that allows the user to enter information into a form and update a mysql database. Each record in the database gets an autoincrement unique identifier added to it which is generated by the database itself.

I am trying to automatically pull the information from the record that I just added to the database, along with the unique identifier, so that I can display it to the screen and give the user the opportunity to print the page.

Does anyone have any idea how I might do this. Is there a pull the last record function in mysql that might allow me to do this?

[blindeddie]

what you could do is assign the unique ID of the last inserted record to the variable $id with the mysql_insert_id function (see below) You should put it right after your insert query.

$id= mysql_insert_id();

and then immediatly re-query the database i.e.

"select * from my_table where unique_id = $id"

then output the results of that query any way you see fit

[PHPRookie]

Thank you very much "blindeddie", I will try exactly what you have suggested!