Please help to optimise ID select

[Anon]

Is there any way to get my id interer auto_increment value at the same time when I insert new record?

I do following (I need better way):

$query="insert into vforum(modified,answer_to_id,subthread,date)            // I insert new record here
                    values('$modified','$answer_to_id','$subthread','$date')";
mysql_query($query) or die(mysql_error());

$result=mysql_query("select * from vforum where date='$date'") or die(mysql_error());    // I need my previous record 
while($raw=mysql_fetch_array($result))
{
$thread=$raw[$id];    // here I get id 
}
$query="insert into vforum(thread)       // and I use this id
                    values('$thread')";
mysql_query($query) or die(mysql_error());

Please tel me is there better way to do this? With less queries to the database

[[deleted]]

use mysql_insert_id() to ge the value from the auto_increment column after an insert.