--- results.php 2001/03/05 15:16:49 1.6 +++ results.php 2001/09/18 10:26:46 1.10 @@ -30,13 +30,16 @@ if (! $type) $type="r"; -$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"; # print "$sql"; $sth = $dbh->prepare("$sql"); $sth->execute(); while ($row=$sth->fetchrow_hash()) { $results[]=$row; } + +if ($type == "p") $main_file="presentations"; + $smarty->assign(array( results=>$results, type=>$type