<?
define('HOME',"/home/sites/www.trouptexas.org/web");

$include_path = ini_get('include_path');
$include_path .= ":" . HOME . '.';
ini_set('include_path',$include_path);

require_once('common.php');
require_once('template.php');
require_once('DB.php');

//------------- Database Connection -------------------
$dsn = "mysql://web:web@localhost/troup";
$dbh = DB::connect($dsn);
if(DB::isError($dbh)) {
    database_error($dbh);
}
//-----------------------------------------------------    

global $dbh;

$query = "SELECT title, content, date, user FROM troupArticles ORDER BY date DESC";
$sth = $dbh->prepare($query);
$res = $dbh->execute($sth);
if(DB::isError($res)) database_error($res);

while($row = $res->fetchrow(DB_FETCHMODE_ASSOC)) {
	$outArray[] = $row;
}

$template = inittmpl(array('filename'=>'articles.tmpl','path'=>'/'));
$template->AddParam('content',$outArray);
print $template->Output();

$dbh->disconnect();
?>