include_once "includes/dbConn.php";
include_once "includes/loggedOnPop.php";
if($_REQUEST['theAction'] == "deleteIt"){
$SQL = "DELETE FROM contacts WHERE ID = '" . $_REQUEST['ID'] . "' AND User_ID = '" . $_SESSION['sessionUserID'] . "'";
$result = MySQL($dbName,$SQL) or die(mysql_error());
header("Location: contacts.php");
exit() ;
}
if($_REQUEST['theAction'] == "updateIt"){
$Address_1 = ereg_replace("'","´",$_REQUEST['Address_1']);
$Address_2 = ereg_replace("'","´",$_REQUEST['Address_2']);
$SQL = "UPDATE contacts SET Type = '" . $_REQUEST['Type'] . "', Emergency = '" . $_REQUEST['Emergency'] . "', First_Name = '" . $_REQUEST['First_Name'] . "' , Last_Name = '" . $_REQUEST['Last_Name'] . "' , Email = '" . $_REQUEST['Email'] . "' , Phone = '" . $_REQUEST['Phone'] . "' , Mobile = '" . $_REQUEST['Mobile'] . "' , Work = '" . $_REQUEST['Work'] . "' , Address_1 = '$Address_1' , Address_2 = '$Address_2' , City = '" . $_REQUEST['City'] . "' , State_Residence = '" . $_REQUEST['State_Residence'] . "' , Zip = '" . $_REQUEST['Zip'] . "' , Share_Family = '" . $_REQUEST['Share_Family'] . "' , Share_Network = '" . $_REQUEST['Share_Network'] . "' WHERE ID = '" . $_REQUEST['ID'] . "' AND User_ID = '" . $_SESSION['sessionUserID'] . "'";
$result = MySQL($dbName,$SQL) or die(mysql_error());
header("Location: contacts.php");
exit ;
}
$SQL2 = "SELECT * FROM contacts WHERE ID = '" . $_REQUEST['ID'] . " ' AND User_ID = '" . $_SESSION['sessionUserID'] . "'";
$result2 = MySQL($dbName,$SQL2) or die(mysql_error());
while($myrow2=MySQL_fetch_array($result2)){
$ID = $myrow2["ID"] ;
$First_Name = $myrow2["First_Name"] ;
$Last_Name = $myrow2["Last_Name"] ;
$Email = $myrow2["Email"] ;
$Phone = $myrow2["Phone"] ;
$Mobile = $myrow2["Mobile"] ;
$Work = $myrow2["Work"] ;
$Address_1 = $myrow2["Address_1"] ;
$Address_2 = $myrow2["Address_2"] ;
$City = $myrow2["City"] ;
$State_Residence = $myrow2["State_Residence"] ;
$Zip = $myrow2["Zip"] ;
$Share_Family = $myrow2["Share_Family"] ;
$Share_Network = $myrow2["Share_Network"] ;
$Type = $myrow2["Type"] ;
$Emergency = $myrow2["Emergency"] ;
}
?>
Yada Home - Contact Edit
include 'beforeEndHead.php'; ?>
include "googAna.php"; ?>