db_process_query("insert",$odlTbl,$fldName,$fldValue,"none","none"); } else{ $fldName = "odlOrderedAmount = $odlOrderedAmount,odlStartDate = '$date',odlEndDate = '$date',odlStatus = '$odlStatus',odlPrice = '$odlPrice', odlEntryType = '$drCr', odlDescription = '$odlDescription'"; $db_CMS->db_process_query("update",$odlTbl,$fldName,"none","odlID = '".$odlID."'","none"); } } function updatePaymentInformation() { global $db_CMS, $HTTP_POST_VARS; global $pymTbl, $pymID, $athUserName; $pymID = $HTTP_POST_VARS["pymID"]; $pymMethod = $HTTP_POST_VARS["pymMethod"]; $pymCardType = $HTTP_POST_VARS["pymCardType"]; $pymCardHolderName = $HTTP_POST_VARS["pymCardHolderName"]; $pymCardNumber = $HTTP_POST_VARS["pymCardNumber"]; $pymCardExpiryDate = $HTTP_POST_VARS["pymCardExpiryDate"]; $pymNote = $HTTP_POST_VARS["pymNote"]; $fldName = "pymMethod = '$pymMethod',pymCardType='$pymCardType',pymCardHolderName='$pymCardHolderName',pymCardNumber='$pymCardNumber',pymCardExpiryDate='$pymCardExpiryDate',pymNote='$pymNote'"; $db_CMS->db_process_query("update",$pymTbl,$fldName,"none","pymID='".$pymID."'","none"); } $paymentBtn = $HTTP_POST_VARS["paymentBtn"]; if ($paymentBtn == "Update Payment Details") { updatePaymentInformation(); } else { addUpdateOrderLine(); } ?>