Location: PHPKode > projects > Crown of Evanion > final/news.php
<?php
/*
*   This file is part of 'Crown of Evanion'.
*
*    'Crown of Evanion' is free software; you can redistribute it and/or modify
*    it under the terms of the GNU General Public License as published by
*    the Free Software Foundation; either version 2 of the License, or
*    (at your option) any later version.
*
*    'Crown of Evanion' is distributed in the hope that it will be useful,
*    but WITHOUT ANY WARRANTY; without even the implied warranty of
*    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*    GNU General Public License for more details.
*
*    You should have received a copy of the GNU General Public License
*    along with 'Crown of Evanion'; if not, write to the Free Software
*    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

# Should I mention that after 5 days the news all goes byby? No display on the page. =X
$title = "News";
include("include.php");

if(! $page) {
	$select = mysql_query("SELECT * FROM date ORDER BY id DESC LIMIT 0,6");
	$sel = mysql_query("SELECT * FROM news WHERE month = '$month' AND date = '$dat' AND yaer = '$year' ORDER BY id DESC");
	$num = mysql_num_rows($sel);
	
	echo "<div class=\"news\">";
	
	while ($dae = mysql_fetch_array($select)) {
		$day = $dae[day];
		$month = $dae[month];  
		$dat = $dae[date];
		$year = $dae[yaer];
	
		$sel = mysql_query("SELECT * FROM news WHERE month = '$month' AND date = '$dat' AND yaer = '$year' ORDER BY id DESC");
		$num = mysql_num_rows($sel);				
		 
		if($num > 0) {
			echo "
			<strong>$day, $month $dat, $year
			<UL></strong>
			";	
		}
		while ($news = mysql_fetch_array($sel)) {
			$message = filter($news[message], 0);
			echo "<li><p>$message</p></li>";
		}
		if($num > 0) {
			echo "</UL>";
		}
	}
echo "</div>";
}

include("footer.php");
?>
			
Return current item: Crown of Evanion