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_is_true 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	dpavlin	1.1	<?php
2
3			if (! $type) $type="a";
4
5			$corp_dbh = new DBI("dbi:pg:corp","dpavlin host=localhost","");
6
7	dpavlin	1.2	$sql="select id,town_date,title,body,pdf from news where type='$type' and $visible_is_true order by priority desc,date desc";
8	dpavlin	1.1	# 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			?>