--- results.php 2001/02/20 15:17:06 1.2 +++ results.php 2001/02/28 18:00:26 1.3 @@ -20,6 +20,14 @@ $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); + $sql="select id,title,pdf from news where type='r' and visible order by priority desc,date desc"; +# print "$sql"; + $sth = $dbh->prepare("$sql"); + $sth->execute(); + while ($row=$sth->fetchrow_hash()) { + $results[]=$row; + } + $smarty->assign("results",$results); $main=$smarty->fetch("$main_file.tpl");