obtaining the ID number of the last sql insertion

nozom

basically i have just run a INSERT statement which has added a new user to the database. This person was assigned an ID by mysql from the auto increment function.

Is there a way i can obtain that exact ID without running another select statement to find it. example of what i want below:

$sql=mysql_query("INSERT INTO people SET F_Name='$REQUEST[fname]', S_Name='$REQUEST[sname]' ");

$theid=GETIDFROMTHATSTATEMENT (or whatever 😉 )

cheers,
hugh

jeremuck

mysql_insert_id();

http://us3.php.net/mysql_insert_id

nozom

sweet 😃, between them PHP and Mysql have a solution for just about everything.

cheers,
hugh

lim8

there is a mysql command LAST_INSERT_ID()

but it's not reliable because if another new user added in other PC, especially in web environtment, there is alot traffic.

the LAST_INSERT_ID() will always be the last ID inserted.

Doug_G

The MySQL LAST_INSERT_ID() function is per-connection and is quite safe in a busy environment.