Parent Directory | Revision Log
new dbi, prijevodi, corporate news
1 | dpavlin | 1.1 | <?php |
2 | |||
3 | if (! $type) $type="a"; | ||
4 | |||
5 | dpavlin | 1.3 | $corp_dbh = new DBI("corp","dpavlin host=localhost",""); |
6 | dpavlin | 1.1 | |
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 | ?> |
ViewVC Help | |
Powered by ViewVC 1.1.26 |