Alright here is today's issue of the day. I have two seperate tables
threads
posts
Now I am trying to execute a page where it will first insert certain information into the table [threads] and from there there is one part of the [posts] query that I need to gain one bit of information from that threads in order to complete. So let's say this is what she looks like at the moment.
$threadquery = "INSERT INTO threads set thread_forumid='$forumid', thread_name='$name', thread_open='1', thread_createdby='$_COOKIE[evoboard]'";
mysql_query($threadquery);
$query = "INSERT INTO posts set post_threadid='$threadid', post_name='$name', post_body='$postbody', post_postdate='$time', post_starter='$_COOKIE[evoboard]'";
mysql_query($query);
On the second query where it says post_threadid I need it to somehow retrieve the $threadid which is located in the threads table and is called thread_id. So how could I take that first query and then immediately retrieve the identical results that it executed and be able to select the thread_id that it just created so I can then use it for the second query where it says post_threadid='$threadid', ?
