include ('common/core.php'); ?> $banner = 'N'; // required to show banner in left vertical column ?>
$mid = $_SESSION['mid']; if (sessioncheck()) { updatetimestamp(); $prodcode = decryptvalue($_REQUEST['prodcode']); $orderid = decryptvalue($_REQUEST['oid']); $errormsg = ""; getmemdet ($mid); if(is_numeric($orderid)) { if (isset($sts)) { if($sts=="edit") { global $product_price, $product_disc, $product_delchrg, $total_amount; $getprodprice = new FC_SQL; $table = " $dbrb_product_mst "; $select = "select $dbrb_product_prodprice, $dbrb_product_proddisc, $dbrb_product_delcharges from"; $where = " where $dbrb_product_prodcode = '$prodcode'"; $getprodprice->query($table,$where,$extra="",$select); if ($getprodprice->num_of_rows() > 0) { while ($getprodprice->next_record()) { $product_price = $getprodprice->get_value($dbrb_product_prodprice); $product_disc = $getprodprice->get_value($dbrb_product_proddisc); $product_delchrg = $getprodprice->get_value($dbrb_product_delcharges); } } $getprodprice->free_result(); $total_amount = ($product_price+$product_delchrg)*$prodqty; $insertord = new FC_SQL; $table=" $dbrb_order_dtls set $dbrb_order_rfname='".ucfirst($rfname)."',$dbrb_order_rlname='".ucfirst($rlname)."',$dbrb_order_radd1='".ucfirst($radd1)."',$dbrb_order_radd2='".ucfirst($radd2)."',$dbrb_order_radd3='".ucfirst($radd3)."',$dbrb_order_rstdcode='".$rstd."',$dbrb_order_rtel='".$rtel."',$dbrb_order_rcity='".$rcity."',$dbrb_order_rstate='".ucfirst($rstate)."',$dbrb_order_rcountry='".ucfirst($rcountry)."',$dbrb_order_rpin='".$rpin."',$dbrb_order_mobile='".$mmobile."',$dbrb_order_spmess='".$spmess."',$dbrb_order_prodcode='".$prodcode."',$dbrb_order_prodqty=".$prodqty.",$dbrb_order_prodprice=".$product_price.",$dbrb_order_proddisc=".$product_disc.", $dbrb_order_proddelchrg=".$product_delchrg.", $dbrb_order_totprice=".$total_amount." " ; $where=" where $dbrb_order_mid='".$mid."' and $dbrb_order_id = '".$orderid."' and $dbrb_order_sessid ='".$_SESSION['memsess']."' and $dbrb_order_ordsts='A' "; $select="update "; $insertord->query($table,$where,$extra="",$select); //echo $select.$table.$where; header("location:".$sitename."viewcart.php"); } } ?>