inserting ids

[doddsey_65]

when i insert a new topic into the database its id is generated by the auto incrememnt field tid.

but what i do next is insert the post for that new topic in the post table which has p_pid(post id) and p_tid(the topic id it is for). so how do i generate that p_tid when the topic has just been inserted. i used to do it by inserting the topic then running a query to pull the newest topic if from the database which would mean the post belonged to that topic. but what happens when people are posting several topics at the same time?

[micmania1]

http://php.net/manual/en/function.mysql-insert-id.php

 

Assuming your using mysql, that function will grab the last automatically generated id in your database.

[doddsey_65]

thanks for the reply. im using PDO but found the function PDO::lastInsertId() to work