"; include("path.php3"); include("$absolutepath/includes/connect.php3"); include("$absolutepath/includes/class.FastTemplate.php3"); include("$absolutepath/includes/printnewsitem.php3"); include("$absolutepath/includes/striphtml.php3"); #?day=21&month=03&year=1999 $query = "select * from news where DATE_FORMAT(date,'%m')='$month' and DATE_FORMAT(date,'%Y')='$year' and DATE_FORMAT(date,'%d')='$day' order by date DESC"; #print "$query\n"; $result = MYSQL_QUERY($query); $number = MYSQL_NUMROWS($result); $date = mysql_result($result,$i,"date"); $datequery="select DATE_FORMAT('$date','%b.%e.%Y') as dateme"; $dateresult = MYSQL_QUERY($datequery); $dateformat = mysql_result($dateresult,0,"dateme"); $date2 = mysql_result($result,$g,"date"); $datequery2 ="select DATE_FORMAT('$date','%l:%i %p') as dateme"; $dateresult2 = MYSQL_QUERY($datequery2); $dateformat2 = mysql_result($dateresult2,0,"dateme"); for ($i = 0; $i < $number; $i++) { $updater = stripslashes(mysql_result($result,$i,"news_updater")); $followup = stripslashes(mysql_result($result,$i,"followup")); $news_subject = stripslashes(mysql_result($result,$i,"news_subject")); $news_item = stripslashes(mysql_result($result,$i,"news_item")); $news_item = str_replace("style=\"color: #E7DFE1;\"","style=\"color: #003366;\"",$news_item); $date = mysql_result($result,$i,"date"); $datequery="select DATE_FORMAT('$date','%b.%e.%Y') as dateme"; $dateresult = MYSQL_QUERY($datequery); $dateformat = mysql_result($dateresult,0,"dateme"); $date2 = mysql_result($result,$i,"date"); $datequery2="select DATE_FORMAT('$date','%l:%i %p') as dateme"; $dateresult2 = MYSQL_QUERY($datequery2); $dateformat2 = mysql_result($dateresult2,0,"dateme"); $category = mysql_result($result,$i,"category"); $newsupdateautonumber = stripslashes(mysql_result($result,$i,"autonumber")); $autonumber = $newsupdateautonumber; printnewsitem($updater,$news_subject,$news_item,$dateformat,$dateformat2,$followup,$autonumber,1,$category); } echo ""; if($template != "1") { include("".$path."/templates/footer.php"); } ?>