Parent Directory | Revision Log | Patch
revision 1.6 by dpavlin, Mon Mar 5 15:16:49 2001 UTC | revision 1.10 by dpavlin, Tue Sep 18 10:26:46 2001 UTC | |
---|---|---|
# | Line 30 $smarty->assign( array ( lpic=>$lpic, le | Line 30 $smarty->assign( array ( lpic=>$lpic, le |
30 | ||
31 | if (! $type) $type="r"; | if (! $type) $type="r"; |
32 | ||
33 | $sql="select id,title,pdf from news where type='$type' and visible order by priority desc,date desc"; | $sql="select id,town_date,title,body,pdf from news where type='$type' and $visible_is_true order by priority desc,date desc"; |
34 | # print "$sql"; | # print "$sql"; |
35 | $sth = $dbh->prepare("$sql"); | $sth = $dbh->prepare("$sql"); |
36 | $sth->execute(); | $sth->execute(); |
37 | while ($row=$sth->fetchrow_hash()) { | while ($row=$sth->fetchrow_hash()) { |
38 | $results[]=$row; | $results[]=$row; |
39 | } | } |
40 | ||
41 | if ($type == "p") $main_file="presentations"; | |
42 | ||
43 | $smarty->assign(array( | $smarty->assign(array( |
44 | results=>$results, | results=>$results, |
45 | type=>$type | type=>$type |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |