from the 'numbersdb' database, use it in the calcs, and use
the accumulated "balance" to update the database. I could
use some help. Thanks
Code: Select all
<?php
mysql_connect("localhost","root","");
mysql_select_db('numbersdb') or die( "Unable to select database");
$query=" SELECT balance FROM numbdata where id='id'";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$balance = $_POST['balance'];
mysql_connect("localhost","root","");
mysql_select_db('ckdb') or die( "Unable to select database");
$query=" SELECT * FROM ckcust ORDER BY dateord ASC";
$result=mysql_query($query);
$num=mysql_num_rows($result);
error_reporting(0);
echo date("m/d/Y") . "<br />";
echo "<table cellspacing=1 cellpadding=0 border=0>
<tr>
<th>Inv#</th>
<th>description</th>
<th>date</th>
<th align=right>charges</th>
<th align=right>paid</th>
<th align=right>owed</th>
<th align=right>bank balance</th>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td align=right>" . sprintf("%.2f",$balance) .
"</td>
<tr>
<TH colspan=9>=======================================================================</TH>
</tr>";
while($row = mysql_fetch_array($result))
{
$owed = $row['charges'] - $row['paidamt'];
$nubalance = $nubalance - $row['paidamt'];
$totpaid = $totpaid + $row['paidamt'];
$totcharges = $totcharges + $row['charges'];
$totowed = $totowed + $owed;
echo "<tr>";
echo "<td>" . $row['invnum'] . "</td>";
echo "<td>" . $row['bname'] . "</td>";
echo "<td>" . $row['dateord'] . "</td>";
echo "<td align=right>" . $row['charges'] . "</td>";
echo "<td align=right>" . $row['paidamt'] . "</td>";
echo "<td align=right>" . sprintf("%.2f",$owed) .
"</td>";
echo "<td align=right>" . sprintf("%.2f",$nubalance) .
"</td>";
}
echo "<tr>";
echo "<th colspan=9>=======================================================================</TH>";
echo "<tr>";
echo "<td>Gtotals</td>";
echo "<td></td>";
echo "<td></td>";
echo "<td align=right>" . sprintf("%.2f",$totcharges) .
"</td>";
echo "<td align=right>" . sprintf("%.2f",$totpaid) .
"</td>";
echo "<td align=right>" . sprintf("%.2f",$totowed) .
"</td>";
echo "</tr>";
echo "</table>";
mysql_query("UPDATE numbdata SET balance='$nubalance'");
mysql_close();
?>