2 replies to this topic

[ckdoublenecks]

This program is to be used at the end of each month to begin
the month with fresh values. When executed there are no
errors, the message "Records have been updated" is displayed,
but no records are changed?

<?php

$stat = mysql_connect("localhost","root","");

$stat = mysql_select_db("prerentdb");

$query = "SELECT name FROM payments Where apt='$apt'";

$stat = @mysql_fetch_assoc(mysql_query($query));

echo $stat["name"];

$result= mysql_query("select * from payments");

while($row=mysql_fetch_array($result))

{

$id=$row['id'];

$paidsum=$row['paidsum'];

$rentdue=$row['rentdue'];

$prevbal=$row['prevbal'];

$latechg=$row['latechg'];

// if no payment or partial payment, add $10 to latechg field

// and amount not paid to prevbal field

if ($paidsum < $rentdue)

{

$latechg = $latechg + 10;

$owe = $rentdue - $paidsum;

$prevbal = $prevbal + $owe;

}

// if over-payment and late field not "L", subtract over-payment

// from prevbal field

if ($paidsum > $rentdue && $late |= 'L')

{

$sub = $paidsum - $rentdue;

$prevbal = $prevbal - $sub;

}

// refresh every record - give every record the below values

$amtpaid = 0;

$hudpay = 0;

$tentpay = 0;

$datepaid = ' ';

$late = ' ';

$paidsum = 0;

$comments = ' ';


$sql = "UPDATE payments SET

$amtpaid, $prevbal, $hudpay, $tentpay, $datepaid, $late, $comments, $paidsum";


mysql_query($sql) ;

}

echo "Records have been updated";

?>

[WingedPanther]

You aren't setting your fields to values. The SQL you are sending is "UPDATE payments SET 0, ???, 0, 0, , , , 0" That isn't a valid SQL statement, and certainly won't update your field values. You want something like

$sql = "UPDATE payments SET amtpaid=$amtpaid, prevbal=$prevbal, hudpay=$hudpay, tentpay=$tentpay, datepaid=$datepaid, late=$late, comments=$comments, paidsum=$paidsum";

[Alexander]

Quote

$late |= 'L'

| is inclusive OR, I believe you meant ! as in NOT