<?
if (!$date)
$date='ExpireDate';
?><HTML>
<HEAD>
</HEAD>
<body background="bg.jpg" bgcolor="#CCCC99" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" leftmargin="20" topmargin="10">
<FONT SIZE=+1 FACE="arial"><font size="+2"><B>Account <? echo $date ?> Query</B></FONT>
<BR>
<A HREF="expire.php?date=ExpireDate">ExpireDate</A>
<A HREF="expire.php?date=CreateDate">CreateDate</A>
<A HREF="expire.php?date=LastUse">LastUse</A>
<?
$sql="select FirstName, LastName, Suburb, CustomerID, VISP, $date
from MasterAccounts
WHERE (to_days($date) - to_days(now()))<7 AND
(to_days($date) - to_days(now()))>-30
ORDER BY $date DESC";
if ($date=='LastUse')
$sql="SELECT FirstName, LastName, Suburb, CustomerID, VISP, $date
FROM MasterAccounts
WHERE (TO_DAYS(now()-TO_DAYS($date)) < 90
ORDER BY LastUse
";
#echo $sql;
include "mysql.inc.php";
$result=mysql_query($sql);
if (!$result){
print "No records found!";
exit;
}
while ($row=mysql_fetch_array($result)){
$vsql="SELECT VISPName FROM VISP WHERE VISPID=$row[VISP]";
$vres=mysql_result(mysql_query($vsql),0);
?>
<P><? if ($vres) echo "$vres";?> <A HREF="user.php?ID=<? echo $row[CustomerID] ?>"><? echo
"$row[FirstName]
$row[LastName]"; ?></A>
<? if ($type=="P")
echo "H: $row[PhoneHome] W: $row[PhoneWork]";
if ($type=="C")
echo " <B>$row[Company]</B> ";
if ($lastmodified)
echo " $row[LastModifyDate]";
echo " $row[ExpireDate]";
?>
</P>
<?
}
?></font>
</BODY>
</HTML>