require_once("../conn.php");
require_once("access.php");
include_once("LeftStyles.php");
?>
if(isset($_GET[s1]))
{
$exp1 = mktime(0,0,0,date(m), date(d) + $_GET[days], date(Y));
$exp2 = mktime(23,59,59,date(m), date(d) + $_GET[days], date(Y));
$q1 = "select *, from_unixtime(DatePosted, '%b-%d-%Y') as dp, from_unixtime(DateExpired, '%b-%d-%Y') as de from coupons_listings where DateExpired between '$exp1' and '$exp2' ";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) == '0')
{
echo "
No results.";
exit();
}
?>
Title & Description |
Date |
Expire |
$col = "white";
while($a1 = mysql_fetch_array($r1))
{
if($col == "white")
{
$col = "dddddd";
}
else
{
$col = "white";
}
if($a1[PriorityLevel] == '5')
{
$pri = "$a1[PriorityName]";
}
else
{
$pri = "";
}
$desc = substr($a1[Description], 0, 30);
echo "\n\t$a1[Title] $pri - $desc | \n\t$a1[dp] | \n\t$a1[de] | \n
\n ";
}
echo "
\n\n";
}
?>