db2

[rahaiffi]

i have 2 tables in database..both use a same primary key (id).i want,when user insert data in second table,primary key(id) is same with first table...This my coding to insert data for first database..

$query = "INSERT INTO mohon VALUES ('','$nama','$bahagian','$tarikh','$masa','$tujuan','$tarikhprj','$destinasi','$jam','$minit','$waktu','$jam2','$minit2','$waktu2')";
$result = mysql_db_query($dbname,$query);

				if($result) {
							header("Location:papar2");

					}

And this is coding to insert data in second database.

$query = "INSERT INTO keputusan VALUES ('$keputusan','$kenderaan','$pemandu','$pagawai','$jawatan',
'$tarikh2','$masa2')";
$result = mysql_db_query($dbname,$query);

if(result) {
header("Location:paparkeputusan.php");
}

But the second coding cannot insert in database..How to use a coding to insert the database ang Primary key(id) value is same..

[liquorvicar]

first, please use the board's PHP tags to display PHP code properly.

secondly, this line

if(result) {
header("Location: parkeputusan.php");
} 

is probably wrong. should be $result not result, right?

third, when you say you can't insert into the DB, what error are you getting? have you tried echoing out the error, like this:

$result = mysql_db_query($dbname,$query) or die (mysql_error());

[rahaiffi]

how to set a primary key in second table have a same value in first table?My primary key is auto increment..

[liquorvicar]

set the ID field in the second table to a PRIMARY key (NOT auto-increment). then grab the ID from the first insert using mysql_insert_id and then add that to the second insert statment.

[rahaiffi]

i still have a problem to set a same value to primary key in both of tables..i try to do LAST_INSERT_ID()..the data successful insert into table but value still not same as value ID in first table...

this my coding to insert data in first table...

$tarikh = date("d-m-Y",time());
			$masa = date("H:i:s",time());

		$query = "INSERT INTO mohon VALUES ('NULL','$nama','$bahagian','$tarikh','$masa','$tujuan','$tarikhprj','$destinasi','$jam','$minit','$waktu','$jam2','$minit2','$waktu2')";
		$result = mysql_db_query($dbname,$query);

				if($result) {
							header("Location:papar2");
							}

and this coding to insert data in second table....

<?
include 'dbase.php';

$tarikh2 = date("d-m-Y",time());
$masa2 = date("H:i:s",time());

$query = "INSERT INTO keputusan VALUES ('LAST_INSERT_ID()','$keputusan','$kenderaan','$pemandu','$pagawai','$jawatan',
'$tarikh2','$masa2')";
$result = mysql_db_query($dbname,$query);

if($result) {
header("Location:paparkeputusan?id = $id.php");
}
?>