"Wee Chua" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
> Is it possible that I would get the wrong ID (Not the ID I just inserted
in
> Auto_Increment field) by using mysql_insert_id function if someone is also
> inserting record at the same time? How does mysql_insert_id work
accurately?
>
> Thanks,
> Wee

You can get the last auto_inc with the following query:
    "SHOW TABLE STATUS 'my_table_having_an_autoinc'"
and then lookup the field "Auto_increment" in the result set.

Best regards

Christian




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to