RE: [PHP] ID value

If you are using mysql as your database, you can use mysql_insert_id. See http://www.php.net/manual/en/function.mysql-insert-id.php for more info :) HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 smasiello@chekinc.com -----Original Message----- From: Robert Morrissey [mailto:robert@NOSPAMcrazymoose.co.uk] Sent: Tuesday, January 23, 2001 10:17 AM To: php-general@lists.php.net Subject: [PHP] ID value Hi, I wonder whether anyone can shed some light onto this for me... Say I have this example insert: $sql = "INSERT INTO songs (id,name,url) VALUES ('','Foobar','test.php?id=<id>)"; The id is autoincrement so obviously left blank, yet I'd like to put it into the url where <id> is. How do I go about dragging back the id even though it is being created (I suppose) while the statement is being made -- is it possible or do I have to do something hackish? Sorry if that's a simple problem... Regards, Robert Morrissey -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net