I think you want this. $sql = "INSERT INTO table (cod, nome, email) VALUES ('', '$nome', '$email')"; $result = mysql_query($sql); $cod = mysql_insert_id();
The $cod is the primery key. Hope it helps. Bruno Gimenes Pereti. ----- Original Message ----- From: "Matt Stewart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 9:57 AM Subject: [PHP-DB] getting results from INSERT > What i'm after is getting the primary key for a record that's just been > added - I have an image file upload accompanying a database addition, and > the image gets renamed $unique_ID.jpeg > only problem is that the current method inserts the information, which auto > produces the primary key, but the only way i know to extract that is by > doing a SELECT, searching for all the matching values to the ones just > entered, and if two entries are the same(except for the primary key - which > is unknown), the image will replace the earlier entry, rather than the one i > actually want it to be for. Is there a way of returning this primary key > immediately after that record is created? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]