Code: Select all
<?php?>
<HTML><HEAD>
<script type="text/javascript">
var dateNow = new Date();
var dayNow = dateNow.getDate();
var showdate = (dateNow.getMonth()+1)+"/"+dateNow.getDate()+"/"+dateNow.getFullYear();
showdate.value = showdate;
</script>
</HEAD><body></body></html>
<?php
include("getinvno.php");
mysql_connect(localhost,root,"");
mysql_select_db(oodb) or die( "Unable to select database");
$query="SELECT payrec, ordernum, invnum, bname, bstreet, bcity, bstate, bzip, contact, sname, sstreet, scity, sstate, szip, terms, fob, shipdate, shipamt, dateord, datecomp, datepaid, qty, descr, charges, paidamt, tax, amtdue, paidsum FROM oocust WHERE payrec = 'R' AND pd = ' '";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
while(list($payrec, $ordernum, $invnum, $bname, $bstreet, $bcity, $bstate, $bzip, $contact, $sname, $sstreet, $scity, $sstate, $szip, $terms, $fob, $shipdate, $shipamt, $dateord, $datecomp, $datepaid, $qty, $descr, $charges, $paidamt, $tax, $amtdue, $paidsum)= mysql_fetch_row($result))
{
echo "<b><center><font size=+2><br /><br /><br /><br /><br />Invoice</center></b></font><br /><br />";
// echo "Date: $row['showdate']<br />";
echo "<b>Invoice No: $invnum</b></b><br />"; }
}
?>