copy ข้อมูลที่เป็นไพรมารีย์คีย์จากตารางหนึ่งไปอีกตาราง

$sql_sighting = 'insert into sighting (....) values( .....)';
$db->query($sql_sighting) or die(...);
$sighting_id = $db->insert_id;

$sql_dolpin_sighting = "insert into dolphin_sighting (sighting_id) values( $sighting_id)";

$sql = mysql_query("SELECT MAX(Sighting_id) AS Sighting_id FROM sighting;");
		$data = mysql_fetch_array($sql);
		$strSQL4 = "INSERT INTO dolphin_sighting ";
		$strSQL4 .="(Dolphin_id,Sighting_id, Behavior_id) VALUES ('".$_POST["dolphin_sighting"]."', '".$data[0]."', '".$_POST["Behavior_Dol"]."')";
		$objQuery = mysql_query($strSQL4);

mysql_query( 'insert ......') or die( '/////');
$insert_id = mysql_insert_id();
$new_statement = 'insert into newtable set new_id = '.$insert_id;