UPDATE t_dontn_new
SET amt_adm = amt * 0.1
, amt_net = amt * 0.9
WHERE dontn_id = NEW.dontn_id;
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO t_dontn_new (dontn_id, desig_id, ck_nbr, amt, don_comment, amt_adm, amt_net) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['dontn_id'], "int"),
GetSQLValueString($_POST['desig_id'], "int"),
GetSQLValueString($_POST['ck_nbr'], "text"),
GetSQLValueString($_POST['amt'], "double"),
GetSQLValueString($_POST['don_comment'], "text"));
GetSQLValueString($_POST['amt_adm'], "double"));
GetSQLValueString($_POST['amt_net'], "double"));
mysql_select_db($database_ibt_dbc, $ibt_dbc);
$Result1 = mysql_query($insertSQL, $ibt_dbc) or die(mysql_error());
$insertGoTo = "enter_don_new.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO t_dontn_new (dontn_id, desig_id, ck_nbr, amt, don_comment, amt_adm, amt_net) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['dontn_id'], "int"),
GetSQLValueString($_POST['desig_id'], "int"),
GetSQLValueString($_POST['ck_nbr'], "text"),
GetSQLValueString($_POST['amt'], "double"),
GetSQLValueString($_POST['don_comment'], "text"));
GetSQLValueString($_POST['amt_adm'], "double"));
GetSQLValueString($_POST['amt_net'], "double"));
mysql_select_db($database_ibt_dbc, $ibt_dbc);
$Result1 = mysql_query($insertSQL, $ibt_dbc) or die(mysql_error());
$insertGoTo = "enter_don_new.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
Thanks.if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$amt = doubleval($_POST['amt']);
$amt_adm = $amt * 0.10;
$amt_net = $amt - $amt_adm; // $amt * 0.90
$insertSQL = sprintf("INSERT INTO t_dontn_new (dontn_id, desig_id, ck_nbr, amt, don_comment, amt_adm, amt_net) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['dontn_id'], "int"),
GetSQLValueString($_POST['desig_id'], "int"),
GetSQLValueString($_POST['ck_nbr'], "text"),
GetSQLValueString($amt, "double"),
GetSQLValueString($_POST['don_comment'], "text"));
GetSQLValueString($amt_adm, "double"));
GetSQLValueString($amt_net, "double"));
mysql_select_db($database_ibt_dbc, $ibt_dbc);
$Result1 = mysql_query($insertSQL, $ibt_dbc) or die(mysql_error());
$insertGoTo = "enter_don_new.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
In other words, what happens with just this.
Open in new window