$grenzdatum = mktime(date("H"),date("i"),date("s"), date("m")-6, date("d"), date("Y")); // aktuelles Datum - 6 Monate
$grenzdatum = strftime ("%Y-%m-%d %H:%M:%S", $grenzdatum); // grenzdatum wie in Db
include('dbconnect.php');
$db = mysql_select_db("resale1")
or die ("System database is down");
$query = "SELECT id,groupid,firma,DATE_FORMAT(date, '%d.%m.%Y'),datei,kategorie_de,kategorie_en FROM newsletterkunden n1 WHERE date = ( SELECT MAX(n2.date) FROM newsletterkunden n2 WHERE n1.firma = n2.firma) and login!='tom' and date>'$grenzdatum' order by date DESC ";
$result = mysql_query ($query)
or die ("There are no results!");
print "\n";
while(list($id,$groupid,$firma,$date,$datei,$kategorie_de,$kategorie_en) = mysql_fetch_row($result)){
print "";
print " $date | ";
print " $firma [PDF] | ";
print " $groupid. $kategorie_de | ";
print " ";
}
print " \n";
?>
|