--- investor.php	2001/03/12 23:41:49	1.4
+++ investor.php	2001/03/17 16:27:06	1.7
@@ -32,7 +32,7 @@
 } else {
 	$dbh->dbh_do("set datestyle='german'");
 
-	$sql="select date(date),time(date),type,current,change,high,low,open from stocks order by stocks.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()) {