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?

[manmadareddy]

Use mysql_insert_id() function to get the id of latest inserted record.