My Delivery Locations

[insert_php]

if (empty($_REQUEST[“cusid”])) { echo “no customer link”; $cusid = 0; }
else { $cusid = $_REQUEST[“cusid”]; }
if (empty($_REQUEST[“orderid”])) { $orderid = 0; }
else { $orderid = $_REQUEST[“orderid”]; }
if (empty($_REQUEST[“subBTN”])) { $subBTN = ”; }
else { $subBTN = $_REQUEST[“subBTN”]; }
if (empty($_REQUEST[“hpass”])) { $hpass = ”; }
else { $hpass = $_REQUEST[“hpass”]; }
if (empty($_REQUEST[“mytype”])) { $mytype = ”; }
else { $mytype = $_REQUEST[“mytype”]; }
if (empty($_REQUEST[“fullupdate”])) { $fullupdate = ”; }
else { $fullupdate = $_REQUEST[“fullupdate”]; }

if(substr($subBTN,0,6) == “Update” ) {

if (empty($_POST[“DelLocName”])) { $DelLocName = ”; }
else { $DelLocName = $_POST[“DelLocName”]; }
if (empty($_POST[“DelLocNbr”])) { $DelLocNbr = ”; }
else { $DelLocNbr = $_POST[“DelLocNbr”]; }
if (empty($_POST[“DelPhone”])) { $DelPhone = ”; }
else { $DelPhone = $_POST[“DelPhone”]; }
if (empty($_POST[“DelAddress1″])) { $DelAddress1 = ”; }
else { $DelAddress1 = $_POST[“DelAddress1”]; }
if (empty($_POST[“DelAddress2″])) { $DelAddress2 = ”; }
else { $DelAddress2 = $_POST[“DelAddress2”]; }
if (empty($_POST[“DelCity”])) { $DelCity = ”; }
else { $DelCity = $_POST[“DelCity”]; }
if (empty($_POST[“DelState”])) { $DelState = ”; }
else { $DelState = $_POST[“DelState”]; }
if (empty($_POST[“DelZipcode”])) { $DelZipcode = ”; }
else { $DelZipcode = $_POST[“DelZipcode”]; }
if (empty($_POST[“DelEmail”])) { $DelEmail = ”; }
else { $DelEmail = $_POST[“DelEmail”]; }
if (empty($_POST[“DelEmail2″])) { $DelEmail2 = ”; }
else { $DelEmail2 = $_POST[“DelEmail2”]; }

if(intval($mytype) == 1) {
$sql =”UPDATE sc_customer SET `cus-del-address1` = ‘$DelAddress1’,
`cus-del-address2` = ‘$DelAddress2’, `cus-del-city` = ‘$DelCity’, `cus-del-state` = ‘$DelState’, `cus-del-zip` = ‘$DelZipcode’, `cus-del-locname` = ‘$DelLocName’, `cus-del-phone` = ‘$DelPhone’, `cus-del-email` = ‘$DelEmail’, `cus-del-locnbr` = ‘$DelLocNbr’, `cus-del-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;
}
else if(intval($mytype) == 2) {
$sql = “UPDATE sc_customer SET `cus-del2-address1` = ‘$DelAddress1’,
`cus-del2-address2` = ‘$DelAddress2’, `cus-del2-city` = ‘$DelCity’, `cus-del2-state` = ‘$DelState’, `cus-del2-zip` = ‘$DelZipcode’, `cus-del2-locname` = ‘$DelLocName’, `cus-del2-phone` = ‘$DelPhone’, `cus-del2-locnbr` = ‘$DelLocNbr’, `cus-del2-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 3) {
$sql =”UPDATE sc_customer SET `cus-del3-address1` = ‘$DelAddress1’,
`cus-del3-address2` = ‘$DelAddress2’, `cus-del3-city` = ‘$DelCity’, `cus-del3-state` = ‘$DelState’, `cus-del3-zip` = ‘$DelZipcode’, `cus-del3-locname` = ‘$DelLocName’, `cus-del3-phone` = ‘$DelPhone’, `cus-del3-locnbr` = ‘$DelLocNbr’, `cus-del3-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 4) {
$sql =”UPDATE sc_customer SET `cus-del4-address1` = ‘$DelAddress1’,
`cus-del4-address2` = ‘$DelAddress2’, `cus-del4-city` = ‘$DelCity’, `cus-del4-state` = ‘$DelState’, `cus-del4-zip` = ‘$DelZipcode’, `cus-del4-locname` = ‘$DelLocName’, `cus-del4-phone` = ‘$DelPhone’, `cus-del4-locnbr` = ‘$DelLocNbr’, `cus-del4-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 5) {
$sql =”UPDATE sc_customer SET `cus-del5-address1` = ‘$DelAddress1’,
`cus-del5-address2` = ‘$DelAddress2’, `cus-del5-city` = ‘$DelCity’, `cus-del5-state` = ‘$DelState’, `cus-del5-zip` = ‘$DelZipcode’, `cus-del5-locname` = ‘$DelLocName’, `cus-del5-phone` = ‘$DelPhone’, `cus-del5-locnbr` = ‘$DelLocNbr’, `cus-del5-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 6) {
$sql =”UPDATE sc_customer SET `cus-del6-address1` = ‘$DelAddress1’,
`cus-del6-address2` = ‘$DelAddress2’, `cus-del6-city` = ‘$DelCity’, `cus-del6-state` = ‘$DelState’, `cus-del6-zip` = ‘$DelZipcode’, `cus-del6-locname` = ‘$DelLocName’, `cus-del6-phone` = ‘$DelPhone’, `cus-del6-locnbr` = ‘$DelLocNbr’, `cus-del6-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 7) {
$sql =”UPDATE sc_customer SET `cus-del7-address1` = ‘$DelAddress1’,
`cus-del7-address2` = ‘$DelAddress2’, `cus-del7-city` = ‘$DelCity’, `cus-del7-state` = ‘$DelState’, `cus-del7-zip` = ‘$DelZipcode’, `cus-del7-locname` = ‘$DelLocName’, `cus-del7-phone` = ‘$DelPhone’, `cus-del7-locnbr` = ‘$DelLocNbr’, `cus-del7-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 8) {
$sql =”UPDATE sc_customer SET `cus-del8-address1` = ‘$DelAddress1’,
`cus-del8-address2` = ‘$DelAddress2’, `cus-del8-city` = ‘$DelCity’, `cus-del8-state` = ‘$DelState’, `cus-del8-zip` = ‘$DelZipcode’, `cus-del8-locname` = ‘$DelLocName’, `cus-del8-phone` = ‘$DelPhone’, `cus-del8-locnbr` = ‘$DelLocNbr’, `cus-del8-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 9) {
$sql =”UPDATE sc_customer SET `cus-del9-address1` = ‘$DelAddress1’,
`cus-del9-address2` = ‘$DelAddress2’, `cus-del9-city` = ‘$DelCity’, `cus-del9-state` = ‘$DelState’, `cus-del9-zip` = ‘$DelZipcode’, `cus-del9-locname` = ‘$DelLocName’, `cus-del9-phone` = ‘$DelPhone’, `cus-del9-locnbr` = ‘$DelLocNbr’, `cus-del9-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}
else if(intval($mytype) == 10) {
$sql =”UPDATE sc_customer SET `cus-del10-address1` = ‘$DelAddress1’,
`cus-del10-address2` = ‘$DelAddress2’, `cus-del10-city` = ‘$DelCity’, `cus-del10-state` = ‘$DelState’, `cus-del10-zip` = ‘$DelZipcode’, `cus-del10-locname` = ‘$DelLocName’, `cus-del10-phone` = ‘$DelPhone’, `cus-del10-locnbr` = ‘$DelLocNbr’, `cus-del10-email2` = ‘$DelEmail2’ WHERE `cus-id` = “.$cusid;

}

$result = MySQL_query($sql);

$mytype = ”;

}

if($cusid != 0) {

if($mytype == ”) {

echo “

“;
$result = mysql_query(“SELECT * FROM sc_customer WHERE `cus-id` = ‘$cusid'”);
if(!mysql_num_rows($result)) { echo “none”; }
else { while($row = mysql_fetch_array($result)) {

echo “

“;

echo “

“;

echo “

“;

echo “

“;

echo “

“;

echo “

“;

echo “

“;

echo “

“;

echo “

“;

echo “

“;

}}

echo “

1. “;
echo $row[‘cus-del-locname’].”, “.$row[‘cus-del-address1’].” “.$row[‘cus-del-address2’].” “.$row[‘cus-del-city’].” “.$row[‘cus-del-state’].” “.$row[‘cus-del-zip’].” “.$row[‘cus-del-phone’];
echo “
Update Location 1
2. “;
echo $row[‘cus-del2-locname’].”, “.$row[‘cus-del2-address1’].” “.$row[‘cus-del2-address2’].” “.$row[‘cus-del2-city’].” “.$row[‘cus-del2-state’].” “.$row[‘cus-del2-zip’].” “.$row[‘cus-del2-phone’];
echo “
Update Location 2
3. “;
echo $row[‘cus-del3-locname’].”, “.$row[‘cus-del3-address1’].” “.$row[‘cus-del3-address2’].” “.$row[‘cus-del3-city’].” “.$row[‘cus-del3-state’].” “.$row[‘cus-del3-zip’].” “.$row[‘cus-del3-phone’];
echo “
Update Location 3
4. “;
echo $row[‘cus-del4-locname’].”, “.$row[‘cus-del4-address1’].” “.$row[‘cus-del4-address2’].” “.$row[‘cus-del4-city’].” “.$row[‘cus-del4-state’].” “.$row[‘cus-del4-zip’].” “.$row[‘cus-del4-phone’];
echo “
Update Location 4
5. “;
echo $row[‘cus-del5-locname’].”, “.$row[‘cus-del5-address1’].” “.$row[‘cus-del5-address2’].” “.$row[‘cus-del5-city’].” “.$row[‘cus-del5-state’].” “.$row[‘cus-del5-zip’].” “.$row[‘cus-del5-phone’];
echo “
Update Location 5
6. “;
echo $row[‘cus-del6-locname’].”, “.$row[‘cus-del6-address1’].” “.$row[‘cus-del6-address2’].” “.$row[‘cus-del6-city’].” “.$row[‘cus-del6-state’].” “.$row[‘cus-del6-zip’].” “.$row[‘cus-del6-phone’];
echo “
Update Location 6
7. “;
echo $row[‘cus-del7-locname’].”, “.$row[‘cus-del7-address1’].” “.$row[‘cus-del7-address2’].” “.$row[‘cus-del7-city’].” “.$row[‘cus-del7-state’].” “.$row[‘cus-del7-zip’].” “.$row[‘cus-del7-phone’];
echo “
Update Location 7
8. “;
echo $row[‘cus-del8-locname’].”, “.$row[‘cus-del8-address1’].” “.$row[‘cus-del8-address2’].” “.$row[‘cus-del8-city’].” “.$row[‘cus-del8-state’].” “.$row[‘cus-del8-zip’].” “.$row[‘cus-del8-phone’];
echo “
Update Location 8
9. “;
echo $row[‘cus-del9-locname’].”, “.$row[‘cus-del9-address1’].” “.$row[‘cus-del9-address2’].” “.$row[‘cus-del9-city’].” “.$row[‘cus-del9-state’].” “.$row[‘cus-del9-zip’].” “.$row[‘cus-del9-phone’];
echo “
Update Location 9
10. “;
echo $row[‘cus-del10-locname’].”, “.$row[‘cus-del10-address1’].” “.$row[‘cus-del10-address2’].” “.$row[‘cus-del10-city’].” “.$row[‘cus-del10-state’].” “.$row[‘cus-del10-zip’].” “.$row[‘cus-del10-phone’];
echo “
Update Location 10

“;

}
else {

echo “

“;
echo ““;
echo ““;

echo “

“;

$d = substr($mytype,1);
echo ““;

$result = mysql_query(“SELECT * FROM sc_customer where `cus-id` = ‘$cusid'”);
if(!mysql_num_rows($result)) { }
else { while($row = mysql_fetch_array($result)) {

if(intval($d) == 1) {
$DelAddress1 = $row[‘cus-del-address1’];
$DelAddress2 = $row[‘cus-del-address2’];
$DelCity = $row[‘cus-del-city’];
$DelState = $row[‘cus-del-state’];
$DelZipcode = $row[‘cus-del-zip’];
$DelLocName = $row[‘cus-del-locname’];
$DelPhone = $row[‘cus-del-phone’];
$DelEmail = $row[‘cus-del-email’];
$DelLocNbr = $row[‘cus-del-locnbr’];
$DelEmail2 = $row[‘cus-del-email2’];
}
else if (intval($d) == 2) {
$DelAddress1 = $row[‘cus-del2-address1’];
$DelAddress2 = $row[‘cus-del2-address2’];
$DelCity = $row[‘cus-del2-city’];
$DelState = $row[‘cus-del2-state’];
$DelZipcode = $row[‘cus-del2-zip’];
$DelLocName = $row[‘cus-del2-locname’];
$DelPhone = $row[‘cus-del2-phone’];
$DelEmail = $row[‘cus-del2-email’];
$DelLocNbr = $row[‘cus-del2-locnbr’];
$DelEmail2 = $row[‘cus-del2-email2’];
}
else if (intval($d) == 3) {
$DelAddress1 = $row[‘cus-del3-address1’];
$DelAddress2 = $row[‘cus-del3-address2’];
$DelCity = $row[‘cus-del3-city’];
$DelState = $row[‘cus-del3-state’];
$DelZipcode = $row[‘cus-del3-zip’];
$DelLocName = $row[‘cus-del3-locname’];
$DelPhone = $row[‘cus-del3-phone’];
$DelEmail = $row[‘cus-del3-email’];
$DelLocNbr = $row[‘cus-del3-locnbr’];
$DelEmail2 = $row[‘cus-del3-email2’];
}
else if (intval($d) == 4) {
$DelAddress1 = $row[‘cus-del4-address1’];
$DelAddress2 = $row[‘cus-del4-address2’];
$DelCity = $row[‘cus-del4-city’];
$DelState = $row[‘cus-del4-state’];
$DelZipcode = $row[‘cus-del4-zip’];
$DelLocName = $row[‘cus-del4-locname’];
$DelPhone = $row[‘cus-del4-phone’];
$DelEmail = $row[‘cus-del4-email’];
$DelLocNbr = $row[‘cus-del4-locnbr’];
$DelEmail2 = $row[‘cus-del4-email2’];
}
else if (intval($d) == 5) {
$DelAddress1 = $row[‘cus-del5-address1’];
$DelAddress2 = $row[‘cus-del5-address2’];
$DelCity = $row[‘cus-del5-city’];
$DelState = $row[‘cus-del5-state’];
$DelZipcode = $row[‘cus-del5-zip’];
$DelLocName = $row[‘cus-del5-locname’];
$DelPhone = $row[‘cus-del5-phone’];
$DelEmail = $row[‘cus-del5-email’];
$DelLocNbr = $row[‘cus-del5-locnbr’];
$DelEmail2 = $row[‘cus-del5-email2’];
}
else if (intval($d) == 6) {
$DelAddress1 = $row[‘cus-del6-address1’];
$DelAddress2 = $row[‘cus-del6-address2’];
$DelCity = $row[‘cus-del6-city’];
$DelState = $row[‘cus-del6-state’];
$DelZipcode = $row[‘cus-del6-zip’];
$DelLocName = $row[‘cus-del6-locname’];
$DelPhone = $row[‘cus-del6-phone’];
$DelEmail = $row[‘cus-del6-email’];
$DelLocNbr = $row[‘cus-del6-locnbr’];
$DelEmail2 = $row[‘cus-del6-email2’];

}
else if (intval($d) == 7) {
$DelAddress1 = $row[‘cus-del7-address1’];
$DelAddress2 = $row[‘cus-del7-address2’];
$DelCity = $row[‘cus-del7-city’];
$DelState = $row[‘cus-del7-state’];
$DelZipcode = $row[‘cus-del7-zip’];
$DelLocName = $row[‘cus-del7-locname’];
$DelPhone = $row[‘cus-del7-phone’];
$DelEmail = $row[‘cus-del7-email’];
$DelLocNbr = $row[‘cus-del7-locnbr’];
$DelEmail2 = $row[‘cus-del7-email2’];
}
else if (intval($d) == 8) {
$DelAddress1 = $row[‘cus-del8-address1’];
$DelAddress2 = $row[‘cus-del8-address2’];
$DelCity = $row[‘cus-del8-city’];
$DelState = $row[‘cus-del8-state’];
$DelZipcode = $row[‘cus-del8-zip’];
$DelLocName = $row[‘cus-del8-locname’];
$DelPhone = $row[‘cus-del8-phone’];
$DelEmail = $row[‘cus-del8-email’];
$DelLocNbr = $row[‘cus-del8-locnbr’];
$DelEmail2 = $row[‘cus-del8-email2’];
}
else if (intval($d) == 9) {
$DelAddress1 = $row[‘cus-del9-address1’];
$DelAddress2 = $row[‘cus-del9-address2’];
$DelCity = $row[‘cus-del9-city’];
$DelState = $row[‘cus-del9-state’];
$DelZipcode = $row[‘cus-del9-zip’];
$DelLocName = $row[‘cus-del9-locname’];
$DelPhone = $row[‘cus-del9-phone’];
$DelEmail = $row[‘cus-del9-email’];
$DelLocNbr = $row[‘cus-del9-locnbr’];
$DelEmail2 = $row[‘cus-del9-email2’];
}
else if (intval($d) == 10) {
$DelAddress1 = $row[‘cus-del10-address1’];
$DelAddress2 = $row[‘cus-del10-address2’];
$DelCity = $row[‘cus-del10-city’];
$DelState = $row[‘cus-del10-state’];
$DelZipcode = $row[‘cus-del10-zip’];
$DelLocName = $row[‘cus-del10-locname’];
$DelPhone = $row[‘cus-del10-phone’];
$DelEmail = $row[‘cus-del10-email’];
$DelLocNbr = $row[‘cus-del10-locnbr’];
$DelEmail2 = $row[‘cus-del10-email2’];
}
}}

echo ““;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

echo “

“;

echo “

Delivery Location “.$d.”
Location Number:
Location Name:
Location Phone:
Address1:
Address2:
City: “;
echo “State: Zipcode:
Delivery Email:
Delivery Email 2:
“;
echo ““;
echo “

“;
}
echo “

“;
echo ““;
echo ““;
echo ““;
echo “

“;

}/*cusid not 0 */

[/insert_php]