Code: Select all
<?php
session_start();
$_SESSION['sessid'] = $id;
$con = mysql_connect("********);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("******", $con);
mysql_query("INSERT INTO main2 (name, email, deptcity, deptdate, arrivalcity, retdate, pass1name, pass1age, pass1nation, pass2name, pass2age, pass2nation, pass3name, pass3age, pass3nation, pass4name, pass4age, pass4nation, comment) SELECT name, email, deptcity, deptdate, arrivalcity, retdate, pass1name, pass1age, pass1nation, pass2name, pass2age, pass2nation, pass3name, pass3age, pass3nation, pass4name, pass4age, pass4nation, comment FROM main1 WHERE main1.id = $id");
mysql_close($con);
//session_destroy();
?>