find primary key of post

[nathanpacker]

Hey everyone, I wasn't sure if this should go in the php section or this one, so hopefully this is right, if not, move it for me.

I have a form that a user fills out, it posts the information to a MySQL database, and then spits out the information they submitted to the screen, so they can verify it is correct.

I would like to provide a link underneath the information for them to change some of it in case they provided bad info. But I don't know how to get the primary key value yet, because it was just submitted, and I don't have anything to reference it with yet.

The field that is the primary key is called "ID". So how do I get the ID number right after the post, when I don't have anything to reference it to?

[php_daemon]

mysql_insert_id() in php

or
last_insert_id() in mysql

[nathanpacker]

mysql_insert_id() in php

or
last_insert_id() in mysql

Thanks, i'll give that a try.

[nathanpacker]

works perfect by the way. Thanks!