Is there a way...

[dolce]

suppose I have the following database table setup:

table(threadid int(12) NOT NULL auto_increment, something text, primary key (threadid));

is there a way to get the value of threaid just before I insert something into the table, or just after --> what I am leading up to is that I need to know the assigned ID of the row JUST inserted into the table... Or is using two quesries (INSERT, then SELECT)???

[Anon]

Just after you insert use

$whatever = mysql_insert_id();
to get the id if the auto_increment field

-thoMas