returning Insterted rows ID number

[cornbread_eater]

I am using MySQL database. I have a field called ID that auto increments on insert and I would like to retrieve the new ID value without using a new SQL call. Is this possible? If not what is the best way to find this data if there are multiple users updating the table at the same time.

If this is a question for a MySQL forum dont flame me.

[stoppel]

i use this

mysql_insert_id();

this right after the query

[cornbread_eater]

Hmmm...
so basically I did not spend eneough time looking at functions on PHP.net. My bad. thanks for the help though.