Parent Directory | Revision Log
annual, p= has precedence over page name
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 | $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 | ?> |
ViewVC Help | |
Powered by ViewVC 1.1.26 |