--- investor.php	2001/03/12 16:01:22	1.3
+++ investor.php	2001/03/17 16:27:06	1.7
@@ -32,14 +32,18 @@
 } else {
 	$dbh->dbh_do("set datestyle='german'");
 
-	$sql="select date,type,current,change,high,low,open from stocks order by date desc limit 2";
+	$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];
 	}
 
-	$smarty->assign("stock",$stock);
+	if ($time == "23:23:23") $time="CLOSE";
+
+	$smarty->assign(array(stock=>$stock, date=>$date, time=>$time));
 	$main=$smarty->fetch("investor.tpl");
 }
 $smarty->assign("MAIN",$main);