--- results.php	2001/02/19 16:22:20	1.1
+++ results.php	2001/03/05 15:06:53	1.5
@@ -9,6 +9,7 @@
 $section="investor";
 
 $title="INVESTOR'S PAGE";
+if ($menu_item) $title.=" : $menu_item";
 $lpic="investor"; $lext=".jpg";
 $mpic="investors.gif";
 
@@ -16,6 +17,19 @@
 
 $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) );
 
+if (! $type) $type="r";
+
+$sql="select id,title,pdf from news where type='$type' 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(array(
+	results=>$results,
+	type=>$type
+	));
 
 $main=$smarty->fetch("$main_file.tpl");