From: FOURNIER Jacques - GRE
Date: September 28 2000 5:01pm
Subject: Value of an automatically generated ID
List-Archive: http://lists.mysql.com/internals/2
Message-Id: <39D37952.1705088F@sema.fr>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

How to get the value of an automatically generated ID ?

I have read the following chapter of the mySQL documentation :
18.5 How to get the value of an AUTO_INCREMENT column in ODBC
but the solution given doesn't work for me !

This chapter said that just after an insert command, the following
command must be done :
SELECT LAST_INSERT_ID();
but no data is selected with this command.

Here is my (php) code, flightNum is my auto_increment column :
------------
  $sql  = "INSERT INTO cfdFlights (flightNum,licence) VALUES
(NULL,'$licenceSv')";
  $sql2         = "SELECT LAST_INSERT_ID()";
  $result       = mysql_query($sql,$conn);
  $resultLast   = mysql_query($sql2,$conn);

   $newFlightNum = mysql_result($resultLast, 0, "flightNum");
------------
And there is nothing in my variable $newFlightNum after that.

What can I do ?

Even if this solution works, is it a good solution ? Because if between
my insert command and my select command, another program make an insert
command, I think I have the risk to have a wrong ID...

Thanks in advance.

Jacques.
--
___________________________________________
 Jacques Fournier
 Grenoble Email : jacques.fournier@stripped
 Other Email      : jacquesf@stripped
___________________________________________