--- investor.php 2001/03/12 16:01:22 1.3 +++ investor.php 2001/03/12 23:41:49 1.4 @@ -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),type,current,change,high,low,open from stocks order by stocks.date desc 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);