Could not check payments.
Error: ".mysql_error()."");
}else{
$numrows = mysql_num_rows($paycheck);
if($numrows > 0){
$pa = mysql_fetch_array($paycheck);
$pa_id = $pa['ID'];
$payup = mysql_query("UPDATE inv_pay SET invnum='$invnum',amount='$paid',type='$paidtype',trans='$paid_id',dtnum='$dtnum' WHERE ID='$pa_id' LIMIT 1");
if(!$payup){
echo("Could not update payments.
Error: ".mysql_error()."
");
}
}else{
$payup = mysql_query("INSERT INTO inv_pay SET invnum='$invnum',amount='$paid',type='$paidtype',trans='$paid_id',dtnum='$dtnum'");
if(!$payup){
echo("Could not confirm payment.
Error: ".mysql_error()."
");
}
}
}
}
$clear = mysql_query("DELETE FROM inv_ship WHERE invnum='$invnum'");
if(!$clear){
echo("Could not reset shipping record.");
}else{
$prodcount = count($prod_name);
$i = 0;
while($i < $prodcount){
$produp = @mysql_query("INSERT INTO inv_ship SET invnum='$invnum',prod_name='$prod_name2[$i]',carrier='shipaddtype[$i]',charge='$shipaddchg[$i]',status='new',dtup='$dtnum',dtnum='$dtnum'");
if (!$produp) {
echo("Could not update shipping.
Error: ".mysql_error()."
");
}else{
$prodnum = $i + 1;
}
$i = $i + 1;
}
$upit = mysql_query("UPDATE ecoinvoice SET taxtotal='$taxtot',tax='$taxit',subtotal='$subtot',shiptotal='$shiptotal',balance='$balance',payments='$paid' WHERE invnum='$invnum' LIMIT 1");
if(!$upit){
echo("Could not update invoice.
Error: ".mysql_error()."
");
}else{
if($prodnum == $prodcount){
header("Location: $redirect");
}else{
echo("Problems Adding Products to Invoice.
Number of inserts did not equal number of products listed.");
}
}
}
?>