Is it possible to grab the value of the primary key upon creation of row?

Question

Possible Duplicate:
How to get the id of a row i've just inserted php/mysql

I have a form with the fields:

• Name
• Email
• City
• State
• Zip

and the user fills in with valid data... its sent to a (php) script and INSERTed into the db.

Is it possible to grab the auto-incrementing PK id WHEN submitted? E.g. say the PK id for that data I entered is '6' . How do I get this PK value programmatically (via php) upon submission? (Without having to call the last PK ID via SQL ? ) or is via SQL the only way?

Answer 1

mysql_insert_id().

Answer 2

Use this PHP Function:

int mysql_insert_id ([ resource $link_identifier = NULL ] )

source:

http://php.net/manual/en/function.mysql-insert-id.php

Answer 3

With mysql_insert_id

http://php.net/manual/en/function.mysql-insert-id.php

<?php
$id = mysql_insert_id();
?>

Answer 4

Or, if you've moved on to MySQLi, $mysqli->insert_id; or mysqli_insert_id()