[Resolved] Adding

NZ_Kiwi

Hi All i'm having touble getting the thread_id to insert into my database

I have two tables as you can see the thread_id is generated when added to forum_thread, once generated it needs to then insert forum_posts.... what would i need to do to the code below to make this happen!

<?php

session_start();
if (!$_SESSION["valid_user"])
	{
	// User not logged in, redirect to login page
	Header("Location: ../login.php");
	}
	?>
<?php
mysql_connect (localhost, user, pass);
mysql_select_db (table);
?>

<?php

if ($title == "")
{
require("../formerror.php"); 
}
if ($body == "")
{
require("../formerror.php"); 
}

$result = mysql_query ("INSERT INTO forum_thread (`thread_id`,`main_id`,`title`,`username`) Values ('','$main_id','$title','" . $_SESSION["valid_user"] . "')") or die("INSERT error: ".mysql_error()); 



$result3 = mysql_query ("INSERT INTO forum_posts (`id`,`thread_id`,`main_id`,`topic`,`body`,`username`) Values ('','$thread_id','$main_id','$topic','$body','" . $_SESSION["valid_user"] . "')") or die("INSERT error: ".mysql_error()); 

?>

TheDefender

After you run your first query, run [man]mysql_insert_id[/man] to get that inserted ID. Then you have the value to add it into your second query.

NZ_Kiwi

Originally posted by TheDefender
After you run your first query, run [man]mysql_insert_id[/man] to get that inserted ID. Then you have the value to add it into your second query.

Cool as but in the last insert it will make a thread_id and in the new insert "$thread_id" is just a normal variable..

how does it know that "thread_id" is the one i'm wanting to carry over???

$result3 = mysql_query ("INSERT INTO forum_posts (id,thread_id,main_id,topic,body,userna me) Values ('','$thread_id','$main_id','$topic','$body','" . $_SESSION["valid_user"] . "')") or die("INSERT error: ".mysql_error());

TheDefender

$result = mysql_query ("INSERT INTO forum_thread (`thread_id`,`main_id`,`title`,`username`) Values ('','$main_id','$title','" . $_SESSION["valid_user"] . "')") or die("INSERT error: ".mysql_error());  

$thread_id = mysql_insert_id();  // Add this line

$result3 = mysql_query ("INSERT INTO forum_posts  (`id`,`thread_id`,`main_id`,`topic`,`body`,`userna
me`) Values ('','$thread_id','$main_id','$topic','$body','" . $_SESSION["valid_user"] . "')") or die("INSERT error: ".mysql_error());

how does it know that "thread_id" is the one i'm wanting to carry over???

(Assuming the thread_id in the first query is an auto-increment field, the function will know. Do yourself a favor, and just read the manual regarding that function using the link I provided, and you should be able to figure it out from here on out)

NZ_Kiwi

Originally posted by TheDefender
$result = mysql_query ("INSERT INTO forum_thread (`thread_id`,`main_id`,`title`,`username`) Values ('','$main_id','$title','" . $_SESSION["valid_user"] . "')") or die("INSERT error: ".mysql_error());  

$thread_id = mysql_insert_id();  // Add this line

$result3 = mysql_query ("INSERT INTO forum_posts  (`id`,`thread_id`,`main_id`,`topic`,`body`,`userna
me`) Values ('','$thread_id','$main_id','$topic','$body','" . $_SESSION["valid_user"] . "')") or die("INSERT error: ".mysql_error());  
(Assuming the thread_id in the first query is an auto-increment field, the function will know. Do yourself a favor, and just read the manual regarding that function using the link I provided, and you should be able to figure it out from here on out) [/B]

Thanks, all working!!

Cheers

TheDefender

No problem, be sure to mark it resolved.