> $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]
