--- results.php 2001/02/20 15:17:06 1.2 +++ results.php 2001/03/03 12:56:33 1.4 @@ -9,6 +9,7 @@ $section="investor"; $title="INVESTOR'S PAGE"; +if ($menu_item) $title.=" : $menu_item"; $lpic="investor"; $lext=".jpg"; $mpic="investors.gif"; @@ -20,6 +21,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");