Re: [PHP] ID value
$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 Try this: mysql_db_query(" INSERT INTO songs (id,name,url) VALUE ('','Foobar','') "; mysql_db_query($sql); $id=mysql_insert_id($link); mysql_db_query=(" UPDATE songs SET (url='test.php?id=$id') WHERE id=$id "; This should work but notice that you have to do 2 SQL queries and this could slow down executing your script if there is some loop. -- Piotr Duszynski http://www.softomat.com.pl http://filmomat.3miasto.pl http://www.3miasto.pl -- PHP General 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] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 10:17 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General 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]