mysql insert id how to properly make use of

Anon

Someone recently suggested to to find the value of an autoincremented field I should "call mysql_insert_id() immediately after performing the insert". Another person told me this is a function and my code as such won't work.
Can someone elaborate on this?

See the last few lines of code to find the autoincremented variable that is assigned a value as a result of the sqlinsert insert query. Is mysql_insert_id a function (don't know much about how to handle functions yet so if it is please elaborate). Am I specifying the call correctly? Are there any other lines of code I need to add for this to work?

$sqlinsert = "insert into table (fields)

values
('$variablenames', etc.);
$return = mysql_query($sqlinsert,$myconnection) or die ("error message.");

$idtest = mysql_insert_id()

/ IS THE FOLLOWING LINE OF CODE Or OTHER LINES OF CODE NEEDED? /
/ $idtestresult = mysql_query($idtest,$myconnection) or die ("error message."); /

Anon

In your example
$idtest = mysql_insert_id() you would actually need to refer to the query resultid which would be $return for your example and then yes it would igve you last auto-incrmeneted field value for your insert
$idtest = mysql_insert_id($return);

Anon

Louie wrote:

In your example
$idtest = mysql_insert_id() you would >actually need to refer to the query resultid which would be $return for your >example and then yes it would igve you last >auto-incrmeneted field value for your insert
$idtest = mysql_insert_id($return);

Sorry, but the above is not correct!

mysql_insert_id does NOT take a result set as an option but instead the link identifier

http://www.php.net/manual/en/function.mysql-insert-id.php

$id = mysql_insert_id() is fine, or if several connection was made:
$id = mysql_insert_id($conn_id);

Anon

tom one question? Do you read the dates on these threads before placing responses. While you are correct, I am sure if she still needed help she might have asked once or twice since LAST SEPTEMBER!