"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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php