Page 1 of 1

need help with update

Posted: Mon Jan 24, 2011 6:52 pm
by ckdoublenecks
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";
?>

Re: need help with update

Posted: Mon Jan 24, 2011 7:19 pm
by Jonah Bron
Not sure what you're asking/saying, but you're evaluating equality, not assigning those variables. Should be this:

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";
?>
http://php.net/operators.comparison
http://php.net/operators.assignment

Re: need help with update

Posted: Mon Jan 24, 2011 7:42 pm
by ckdoublenecks

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";
?>
did the same

Re: need help with update

Posted: Mon Jan 24, 2011 8:52 pm
by Jonah Bron
Well, what were you expecting?

Re: need help with update

Posted: Tue Jan 25, 2011 9:15 am
by ckdoublenecks
I was expecting it to work after I followed your advice. Is that what you;re asking me?

Re: need help with update

Posted: Tue Jan 25, 2011 10:24 pm
by Jonah Bron
No, I mean what do you expect the script to do? What do you want to happen, and what really happens? In what way does it fall short of your expectations?