--- results.php	2001/03/05 15:06:53	1.5
+++ results.php	2001/03/19 16:47:46	1.8
@@ -1,17 +1,28 @@
 <?php
 require("Smarty.class.php");
-require("conn.inc");
 
 $smarty = new Smarty;
 
 $smarty->assign( array ( Title=>"Pliva d.d." ) );
 
-$section="investor";
+if (isset($from)) {
+	$section=$from;
+} else {
+	$section="investor";
+}
+
+require("conn.inc");
 
-$title="INVESTOR'S PAGE";
+if ($section == "new") {
+	$title="What's New";
+	$lpic="new"; $lext=".jpg";
+	$mpic="new.gif";
+} else {
+	$title="INVESTOR'S PAGE";
+	$lpic="investor"; $lext=".jpg";
+	$mpic="investors.gif";
+}
 if ($menu_item) $title.=" : $menu_item";
-$lpic="investor"; $lext=".jpg";
-$mpic="investors.gif";
 
 $main_file="results";
 
@@ -19,7 +30,7 @@
 
 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 order by priority desc,date desc";
 #	print "$sql";
 $sth = $dbh->prepare("$sql");
 $sth->execute();