--- history.php 2001/02/19 16:22:20 1.1 +++ history.php 2001/02/28 14:14:34 1.2 @@ -14,14 +14,13 @@ $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); - -$sth = $dbh->prepare("select num,name,type,note,street,town,country,phone,fax,email,website from worldwide where type='Subsidiary' order by num"); +$sth = $dbh->prepare("select year,description from history order by num asc"); $sth->execute(); -$menu=""; while ($row=$sth->fetchrow_hash()) { - $data[]=$row; + $history[]=$row; } +$smarty->assign("history",$history); $main=$smarty->fetch("history.tpl"); include("common.inc");