how can i get the inserted data accurately?

[pfchin]

dear all,

can anyone tell me how could i get the inserted record's id (auto_increment) accurately in PHP using mysql database??? i know there is the mysql_insert_id() but is it really the only way to get the id??? however, if there are 2 records insert at the same time (same second) which record will the system choose??? or it will come out an error???

thansk & regards,
pf.chin

[RaS_]

If you've two records, mysql_insert_id() return the last ID's one

[[deleted]]

mysql_insert_id() is perfectly safe.

It will return the last auto_increment value used on the connection that you are using to issue the mysql_insert_id() .

So if you insert a record on connection 1 and it inserts value 56, and another person inserts another record on connection two and it inserts 57, then you will still see 56 on connection 1, becuase that is the value used for your insert.

[pfchin]

Thanks Vincente & RaS ^.
I understand it clearly now, really thanks alot.

regards,
pf.chin😉