--- investor.php	2001/03/17 16:27:06	1.7
+++ investor.php	2001/10/01 14:05:16	1.9
@@ -10,11 +10,7 @@
 
 $smarty->assign("section",$section);
 
-$title="INVESTOR'S PAGE";
-$lpic="investor"; $lext=".jpg";
-$mpic="investors.gif";
-
-if ($menu_item) $title.=" : $menu_item";
+include("section.inc");
 
 $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) );
 
@@ -30,19 +26,7 @@
 	$smarty->assign("analysts",$analysts);
 	$main=$smarty->fetch("analysts.tpl");
 } else {
-	$dbh->dbh_do("set datestyle='german'");
-
-	$sql="select date(date),time(date),stocks.type as type,current,change,high,low,open,ordinal from stocks,stocks_order where stocks_order.type=stocks.type order by stocks.date desc,ordinal asc limit 2";
-	$sth = $dbh->prepare("$sql");
-	$sth->execute();
-	while ($row=$sth->fetchrow_hash()) {
-		$stock[]=$row;
-		$time=$row[time];
-		$date=$row[date];
-	}
-
-	if ($time == "23:23:23") $time="CLOSE";
-
+	include("stocks.inc");
 	$smarty->assign(array(stock=>$stock, date=>$date, time=>$time));
 	$main=$smarty->fetch("investor.tpl");
 }