need help with update
Posted: Mon Jan 24, 2011 6:52 pm
This code clears the fields without executing the if statements ?
Code: Select all
<?php
include ('getnames.php');
if($paidsum < $rentdue)
{
$latechg == $latechg + 10;
}
if($paidsum == $rentdue || $late == 'L')
{
$amtpaid == 0;
$prevbal == 0;
$latechg == 0;
$hudpay == 0;
$tentpay == 0;
$datepaid == ' ';
$late == ' ';
$comments == ' ';
$paidsum == 0;
}
$sql = "UPDATE payments SET
amtpaid = '" . mysql_real_escape_string($_POST['amtpaid']) . "',
prevbal = '" . mysql_real_escape_string($_POST['prevbal']) . "',
latechg = '" . mysql_real_escape_string($_POST['latechg']) . "',
hudpay = '" . mysql_real_escape_string($_POST['hudpay']) . "',
tentpay = '" . mysql_real_escape_string($_POST['tentpay']) . "',
datepaid = '" . mysql_real_escape_string($_POST['datepaid']) . "',
late = '" . mysql_real_escape_string($_POST['late']) . "',
comments = '" . mysql_real_escape_string($_POST['comments']) . "',
paidsum = '" . mysql_real_escape_string($_POST['paidsum']) . "'";
mysql_query($sql) or die("Update query failed.");
echo "Records have been updated";
?>