Re: [PHP] ID value

> $sql = "INSERT INTO songs (id,name,url) VALUES > ('','Foobar','test.php?id=)"; > > The id is autoincrement so obviously left blank, yet I'd like to put it into > the url where is. > > How do I go about dragging back the id even though it is being created (I > suppose) while the statement is

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 [EMAIL PROTECTED] -Original Message- From: Robert Morrissey [mailto:[EMA