connect_errno > 0){
die(‘Unable to connect to database [‘ . $db->connect_error . ‘]’);
}
$sql0 = “SELECT (Max(ID))+1 as NewID FROM tbladdress where ID like ‘9_______'”;
if(!$result = $db->query($sql0)){
die(‘There was an error running the query [‘ . $db->error . ‘]’);
}
while($row = $result->fetch_assoc()){
echo $row[‘NewID’] . ‘
‘;
$NewID = $row[‘NewID’];
}
$sql1 = “INSERT INTO tbladdress SET
ID=”.$NewID.”,
First='”.$_POST[‘First’].”‘,
Last='”.$_POST[‘Last’].”‘;”;
$sql2= “INSERT INTO tblcontact SET
ID=”.$NewID.”,
EUser='”.$_POST[‘EUser’].”‘,
EISP='”.$_POST[‘EISP’].”‘;”;
$sql3 = “INSERT INTO tblsupport SET
CampaignID=’9’,
IndividualID='”.$NewID.”‘;”;
if (!$result = $db->query($sql1)) {
echo (“
Error adding submitted name:”.
mysql_error().”
“);
} else {
echo (“
New Contact has been added.
“);
}
if (!$result = $db->query($sql2)) {
echo (“
Error adding submitted name:”.
mysql_error().”
“);
} else {
echo (“
New Contact has been added.
“);
}
if (!$result = $db->query($sql3)) {
echo (“
Error adding submitted name:”.
mysql_error().”
“);
} else {
echo (“
New Contact has been added.
“);
}
die();
default :
die(“Unknown action : “.$_POST[“action”]);
break;
}
}
?>
First Name: | |
Last Name: | |
Email: | @ |