<?

require_once("_config/smarty.inc.php");

require_once("_config/db.inc.php");

$pageoptions['template'] = "index.tpl";



$query = "
SELECT * FROM News, Crew 
WHERE Crew.crewID = News.crewID ORDER BY date DESC";

$results = $db->query($query);

$news = array();
while ($result = $results->fetch_assoc() )
{
	foreach ($result as $k => $v)
	{
		$result[$k] = fromdb($v);
	}
	
	$result['text'] = nl2br($result['text']);
	array_push($news, $result);
}
$results->close();



$smarty->assign("news", $news);

$smarty->display("default.tpl");

$db->close();
?>