pliva-si/sections/annual.inc

<?php

if (! $type) $type="a";

$corp_dbh = new DBI("dbi:pg:corp","dpavlin host=localhost","");

$sql="select id,town_date,title,body,pdf from news where type='$type' and visible order by priority desc,date desc";
#       print "$sql";
$sth = $corp_dbh->prepare("$sql");
$sth->execute();
while ($row=$sth->fetchrow_hash()) {
        $results[]=$row;
}

$smarty->assign(array(
        results=>$results,
        type=>$type
        ));

$main=$smarty->fetch("annual.tpl");
?>
1	<?php
2
3	if (! $type) $type="a";
4
5	$corp_dbh = new DBI("dbi:pg:corp","dpavlin host=localhost","");
6
7	$sql="select id,town_date,title,body,pdf from news where type='$type' and visible order by priority desc,date desc";
8	# print "$sql";
9	$sth = $corp_dbh->prepare("$sql");
10	$sth->execute();
11	while ($row=$sth->fetchrow_hash()) {
12	$results[]=$row;
13	}
14
15	$smarty->assign(array(
16	results=>$results,
17	type=>$type
18	));
19
20	$main=$smarty->fetch("annual.tpl");
21	?>