Insert info into one database and delete from another.

I am trying to simultaneously insert information into one table and then delete information from another. The information is being copied into the one table successfully but it is not deleting it from the other table.
Thanks in advance:

<?php include('../../connect.php'); ?>

<?php
$UniqueID = mysqli_real_escape_string($dbc, $_POST['UniqueID']);
$DateDeleted = mysqli_real_escape_string($dbc, $_POST['DateDeleted']);
$FirstName = mysqli_real_escape_string($dbc, $_POST['FirstName']);
$LastName = mysqli_real_escape_string($dbc, $_POST['LastName']);
$Team = mysqli_real_escape_string($dbc, $_POST['Team']);
$Email = mysqli_real_escape_string($dbc, $_POST['Email']);
$Gender = mysqli_real_escape_string($dbc, $_POST['Gender']);
$Country = mysqli_real_escape_string($dbc, $_POST['Country']);
$Division = mysqli_real_escape_string($dbc, $_POST['Division']);
$TeamID = mysqli_real_escape_string($dbc, $_POST['TeamID']);
$Reason = mysqli_real_escape_string($dbc, $_POST['Reason']);
$OtherContactInfo = mysqli_real_escape_string($dbc, $_POST['OtherContactInfo']);



//$result = mysqli_query($dbc, "INSERT INTO `Teams`(`Team`, `TeamFirstName`, `TeamLastName`, `TeamFullName`, `AlternateEmails`, `ContactType`, `Division`, `EditedBY`, `FacebookCode`, `FBID`, `JobTitle`, `LastUpdated`, `Notes`, `RegistrationDate`, `TeamCity`, `TeamCountry`, `TeamEmail`, `TeamGender`, `TeamID`, `TeamMobile`, `TeamPhone`, `TeamStreetAddress`) VALUES ('$Team','$TeamFirstName','$TeamLastName','$TeamFullName','$AlternateEmails','$ContactType',$Division,'$EditedBY','$FacebookCode','$FBID','$JobTitle','$LastUpdated','$Notes','$RegistrationDate','$TeamCity','$TeamCountry','$TeamEmail','$TeamGender','$TeamID','$TeamMobile','$TeamPhone','$TeamStreetAddress')");


$result = mysqli_query($dbc, "INSERT INTO DeletedContacts (UniqueID,DateDeleted,FirstName,LastName,Team,Email,Gender,Country,Division,TeamID,Reason,OtherContactInfo) VALUES ('$UniqueID', '$DateDeleted', '$FirstName', '$LastName', '$Team', '$Email', '$Gender', '$Country', '$Division', '$TeamID', '$Reason', '$OtherContactInfo')");

// -- having spaces between my variables screwed everything up. Do not put quotes around the numeric values

$Remove = mysqli_query($dbc, "DELETE FROM Teams WHERE UniqueID = $UniqueID");

 
?>

<html>
<head>
<meta charset="UTF-8">
<meta http-equiv="Content-type" content="text/html; charset=UTF-8">

</head>
<body>

<br>The Following information has been deleted from the database:
<br>Team: <?php echo $Team; ?>
<br>First Name: <?php echo $FirstName; ?>

</body>
<html>

Insert info into one database and delete from another.

swelch15

QuaterPan

swelch15

tangor

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week