Menu
I’m trying to change a working program to add three fields (rentdue+prevbal+ misc=balance) together. Can this be done with PHP or do I need Javascript?
[ICODE]<?php?>
<HTML>
<HEAD>
<script type=”text/javascript”>
var monthNames = [ “January”,”February”,”March”,”April”,”May”,”June”,”July”,
“August”,”September”,”October”,”November”,”December” ];
var today = new Date();
var mmyy = monthNames[today.getMonth()] + “/” + today.getFullYear();
</script>
</HEAD>
<BODY><center>
<font size=+2><b>Hammock Oaks Apartments</font><br><br></center>
Rent Receipt……………..for………………….
</head>
<body>
<script type=”text/javascript”>document.write(mmyy);</script>
</script>
<?
mysql_connect(localhost,root,””);
mysql_select_db(prerentdb) or die( “Unable to select database”);
if(!empty($_POST[“submit”]))
{
$apt = $_POST[‘apt’];
$query=”SELECT name, apt, amtpaid, rentdue, prevbal, misc, datepaid FROM payments Where apt=’$apt'”;
$result=mysql_query($query);
if(mysql_num_rows($result))
{
echo “<form action=’#’ method=’post’><font size=4><b></font> <br /><br /><i>amount
paid is the total paid this month<br /><br /></i>
<table border=’0′>
<tr>
<th>.</th>
</tr>”;
echo “</table>”;
echo “</form>”;
while(list($name,$apt,$amtpaid,$rentdue,$prevbal,$misc,$datepaid)= mysql_fetch_row($result))
{
echo “$name , in apartment $apt has paid $ $amtpaid of the $ $balance owed on this day $datepaid<br />”;
}
}
else{echo “No listing for appartment $apt.<br />Please select another.<br />”;}
}
?>
<form method=”post” action=”#”>
<br />
<input type=”text” name=”apt”/> <p>
<input type=”submit” name=”submit” value=”receipt apartment”/>
</form>[/ICODE]