How do I return the auto incremented ID for each row

[frankivey]

I am building a custom datagrid for a simple customer tracking system and would like to know how do I return the id (which is auto-incremented) for each row so that I may use it to reference the fields (customername, email, payment amount) from each row?

the table structure is as follows (id auto increment, customername, email, payment_amount)

how do I return the [id] for each row in order to reference other fields in the row?

[nnichols]

After your insert statements you can use mysql_insert_id() to return the id of the last auto incremented insert.

[Piranha]

nnichols wrote:

After your insert statements you can use mysql_insert_id() to return the id of the last auto incremented insert.

Is it the last auto incremented or is it the auto incremented that is related to the code you did put in? I mean, if two persons are inserting things at the same time, will you get the right id then? Like this:

[b]Timeline   Person 1                       Person 2[/b]
1          Insert into test...
2                                         Insert into test...
3          $id1 = mysql_insert_id()
4                                         $id2 = mysql_insert_id()

Let's say that the first person 1 is inserting post number 100, then $id1 should be 100. But before person 1 gets the id person 2 inserts something, and the last id is now 101. What will the value of $id1 be, will it be 100 or 101?

[mjax]

Yes, you will get the right ID. mysql_insert_id() will return the last generated id by the current database connection.

[Piranha]

Ty mjax, got a bit confused for a moment there.