14 |
$lpic="investor"; $lext=".jpg"; |
$lpic="investor"; $lext=".jpg"; |
15 |
$mpic="investors.gif"; |
$mpic="investors.gif"; |
16 |
|
|
17 |
|
if ($menu_item) $title.=" : $menu_item"; |
18 |
|
|
19 |
$smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); |
$smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); |
20 |
|
|
21 |
include("common.inc"); |
include("common.inc"); |
22 |
|
|
23 |
$dbh->dbh_do("set datestyle='german'"); |
if ($part == "analyst") { |
24 |
|
$sth = $dbh->prepare("select company,analyst,email from analysts order by company"); |
25 |
$sql="select date,type,current,change,high,low,open from stocks order by date desc limit 2"; |
$sth->execute(); |
26 |
|
while ($row=$sth->fetchrow_hash()) { |
27 |
|
$analysts[]=$row; |
28 |
|
} |
29 |
|
|
30 |
|
$smarty->assign("analysts",$analysts); |
31 |
|
$main=$smarty->fetch("analysts.tpl"); |
32 |
|
} else { |
33 |
|
$dbh->dbh_do("set datestyle='german'"); |
34 |
|
|
35 |
|
$sql="select date,type,current,change,high,low,open from stocks order by date desc limit 2"; |
36 |
|
$sth = $dbh->prepare("$sql"); |
37 |
|
$sth->execute(); |
38 |
|
while ($row=$sth->fetchrow_hash()) { |
39 |
|
$stock[]=$row; |
40 |
|
} |
41 |
|
|
42 |
$sth = $dbh->prepare("$sql"); |
$smarty->assign("stock",$stock); |
43 |
$sth->execute(); |
$main=$smarty->fetch("investor.tpl"); |
|
while ($row=$sth->fetchrow_hash()) { |
|
|
$stock[]=$row; |
|
44 |
} |
} |
|
|
|
|
$smarty->assign("stock",$stock); |
|
|
|
|
|
$main=$smarty->fetch("investor.tpl"); |
|
45 |
$smarty->assign("MAIN",$main); |
$smarty->assign("MAIN",$main); |
46 |
|
|
47 |
$smarty->display("index.tpl"); |
$smarty->display("index.tpl"); |