I have a forum with DB2 using PHP and ODBC_connection when I insert a new thread in my DB I have to link the message to the thread table and to do that I need to get the ID of the thread that was just created.

the problem is how do I get the thread ID back and how do I make sure that it is exactly the one I created, let's say someone posted a new thread exactly the same time I did.??

The ID is of course auto incrementing so I don't know what ID a new thread will get. Is there some function or method that I can use to get the ID of a new just insertet thread??

check to see if DB2 supports the @@identity

i use MSsql so i can't promise you anything