How to retrieve a primary key

[xxreenaxx1]

I have a form that ask user to enter other details but the primary key as this is automated and when they click on Submit button it takes the user to different form. now on this form I would like to retreive the primary that has just been added to the table. How can I do this?

[ronverdonk]

Assuming you are talking about MySQL and  "the ID generated for an AUTO_INCREMENT column by the previous query on success, 0 if the previous query does not generate an AUTO_INCREMENT value, or FALSE if no MySQL connection was established." (PHP manual) you can use the

mysql_insert_id()

function

[xxreenaxx1]

Yes. That works but can I use this printf to save it in a session and use it on a different page.

[gizmola]

It's a value.  You can save it to a variable and output that variable anyway you want.  If you want to store it in a session variable you can do that too.

[xxreenaxx1]

Howwould you do that with a printf? I dont know how so help me out please

[ronverdonk]

Just do

$_SESSION['lastid'] = mysql_insert_id();