include("includes/sessioncheck.php"); ?>
include("upsRate.php"); ?>
//echo $sess_userid."::::::"; sess_userid=1&sess_c=411120091902
$sess_c = $sess_c7;
if ($sess_userid == ""){
?>
}else{
?>
if($uy == "1"){
}else{
$query = "select * from members where memberid = $sess_userid ";
$result = mysql_query($query,$connection);
$prod = mysql_fetch_array($result);
$email = $prod['email'];
$s_company = $prod['company'];
$s_firstname = $prod['firstname'];
$s_lastname = $prod['lastname'];
$s_phone = $prod['phone'];
$s_address = $prod['address'];
$s_city = $prod['city'];
$s_state = $prod['state'];
$s_zip = $prod['zip'];
$s_country = $prod['country'];
}
$query_12 = "select cartid, weight, quantity from carts where sess_car = '$sess_c' order by created_date desc ";
$result_12 = mysql_query($query_12,$connection);
$total_weights = 0;
while (list($cartid12, $weight12, $quantity12) = mysql_fetch_row($result_12)){
$weight_p = $quantity12 * $weight12;
$total_weights = $total_weights + $weight_p;
}
$total_weights = ceil($total_weights);
/*
if($s_country == "AU"){
$countrynumber = "australia";
}else if($s_country == "CA"){
$countrynumber = "canada";
}else if($s_country == "FR"){
$countrynumber = "europe";
}else if($s_country == "DE"){
$countrynumber = "europe";
}else if($s_country == "HK"){
$countrynumber = "eastasia";
}else if($s_country == "IT"){
$countrynumber = "europe";
}else if($s_country == "JP"){
$countrynumber = "eastasia";
}else if($s_country == "MX"){
$countrynumber = "mexico";
}else if($s_country == "NL"){
$countrynumber = "europe";
}else if($s_country == "NZ"){
$countrynumber = "australia";
}else if($s_country == "KR"){
$countrynumber = "eastasia";
}else if($s_country == "TW"){
$countrynumber = "southasia";
}else if($s_country == "GB"){
$countrynumber = "europe";
}else if($s_country == "VN"){
$countrynumber = "southasia";
}
$query_o21 = "select ".$countrynumber." from usps where weight = '$total_weights' ";
$result_o21 = mysql_query($query_o21,$connection);
$prod_o21 = mysql_fetch_array($result_o21);
$intlshipping = $prod_o21['eastasia'];
echo "
query_o21: ".$query_o21;
echo "
intlshipping: ".$intlshipping;
*/
?>
|
include("include_scroll.php"); ?>