MySQL insert & return question

[phence]

If i am inserting information into a table that has an auto_increment 'id' field, is there a way that i can have mysql return to me the id of that record that was just entered?

My main concern is that there will be many users using this insert script and there will be similtaneous inserts, so i want to be sure that the the id's don't get mixed up, so a simple query to pull out the last record inserted is not sufficient.

Thank-you,
phence

[cornercuttinjoe]

use mysql_insert_id()

i think its what you are looking for

example

create table a (id_num mediumint unsigned auto_increment not null,
something varchar(10),
primary key (id_num));

then your php code:
$query = "INSERT INTO a (something) VALUES ('$my_val')";
$result = @($query);

$updated_id_num = mysql_insert_id();

This will provide the incremented id_num for the row in table a that was just inserted.