Two table insert using relationship

[phpjay]

i have two tables 1 is remarks one is tbltracking i have remarks_id as primary key in remarks table and ID as primary key also in tbltracking

 

i need to insert a data in remarks table using selecting the table ID from tbltracking table..

 

structure of my two tables:

remarks:

 

remarks_id: primary key

remarks: varchar(255)

date: time stamp

 

 

tbltracking:

ID: primary key

name:varchar(255)

DateReceived:date

[Kustom_Vegas]

look into using an INSERT SELECT statement

 

http://dev.mysql.com/doc/refman/5.5/en/insert-select.html

[phpjay]

i have a code here i want to update and insert a data.. how i can add insert here in my code where table2.ID= to remarks.ID

 

	 include ('connection.php');

	$con = mysql_connect("$host","$username","$password");
			if (!$con)
			  {
			  die('Could not connect: ' . mysql_error());
			  }

			mysql_select_db("$db", $con);



			$acft = $_POST['acft'];
			$DateIssued = $_POST['DateIssued'];
			$IssuedTo = $_POST['IssuedTo'];
			$ID = $_POST['ID'];
			$remarks = $_POST['remarks'];
			$sql="UPDATE $table2 SET acft='$acft', DateIssued='$DateIssued', IssuedTo='$IssuedTo'  where ID='$ID'";

 

[phpjay]

i have a code here i want to update and insert a data.. how i can add insert here in my code where table2.ID= to remarks.ID

 

	 include ('connection.php');

	$con = mysql_connect("$host","$username","$password");
			if (!$con)
			  {
			  die('Could not connect: ' . mysql_error());
			  }

			mysql_select_db("$db", $con);



			$acft = $_POST['acft'];
			$DateIssued = $_POST['DateIssued'];
			$IssuedTo = $_POST['IssuedTo'];
			$ID = $_POST['ID'];
			$remarks = $_POST['remarks'];
			$sql="UPDATE $table2 SET acft='$acft', DateIssued='$DateIssued', IssuedTo='$IssuedTo'  where ID='$ID'";

[fenway]

You mean keep track of the previously inserted UID?