mysql_insert_id() is secure?

[Anon]

How can I garantee that this function is not going to get a different id from the last if two or more people add at the same time????

Thanks

mysql_insert_id() returns 0 if the previous query does not generate an AUTO_INCREMENT value. If you need to save the value for later, be sure to call mysql_insert_id() immediately after the query that generates the value.

[Anon]

It's because you call it with the link_id.

$number = mysql_insert_id($link_id);

That link_id is for the current script only, another script running at the same time doing an insert will have a different link_id, so it'll get its own number..

This is the most secure way to find out the number of the row you just inserted.

---John Holmes...

[Anon]

What John said. But just to clarify, when the manual says

  If you need to save the value for later, be sure
  to call mysql_insert_id() immediately after the
  query that generates the value

it means <i>immediately in your own script</i> so you don't
issue another query and then expect to be able to still find
the correct autoincrement value.