url variable from a record id when created - or - "building a confirmation page"

[sharp3d]

I am having trouble inserting a MySQL record and going to a query page for it. To understand my setup I attached a chart.

 

Everything works fine, mysql and php, except I do not know how to do is to get a record id (autoindex) from an "insert form" into the url variable of the destination page "confirmation".

 

Obviously this is the first year with dynamic webpages for me but I do have a few dynamic sites in progress and 11 years static html experience, and I would love to know if there is a solution for this.

If it helps, I am using PHP and mysql through GoDaddy and my editor is Dreamweaver.

 

Thank you,

Chris

 

[attachment deleted by admin]

[Daukan]

mysql_insert_id() function returns the id of the last insert