/[pliva-si]/sections/worldwide.inc
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /sections/worldwide.inc

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (show annotations)
Tue Nov 20 08:48:14 2001 UTC (17 years, 6 months ago) by dpavlin
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +1 -1 lines
new dbi, prijevodi, corporate news

1 <?php
2
3 $corp_dbh = new DBI("corp","dpavlin host=localhost","");
4
5 $sth = $corp_dbh->prepare("select num,name,type,note,street,town,country,phone,fax,email,website from worldwide where type='HQ' order by num");
6 $sth->execute();
7 while ($row=$sth->fetchrow_hash()) {
8 $data[]=$row;
9 }
10 $smarty->assign("data",$data);
11 $html=$smarty->fetch("worldwide-list.tpl");
12 unset($data);
13 $smarty->assign("hq",$html);
14
15
16 $sth = $corp_dbh->prepare("select num,name,type,note,street,town,country,phone,fax,email,website from worldwide where type='Subsidiary' order by num");
17 $sth->execute();
18 while ($row=$sth->fetchrow_hash()) {
19 $data[]=$row;
20 }
21 $smarty->assign("data",$data);
22 $html=$smarty->fetch("worldwide-list.tpl");
23 $smarty->assign("subsidiary",$html);
24 unset($data);
25
26
27 $sth = $corp_dbh->prepare("select num,name,type,note,street,town,country,phone,fax,email,website from worldwide where type='Representative Office' order by num");
28 $sth->execute();
29 while ($row=$sth->fetchrow_hash()) {
30 $data[]=$row;
31 }
32 $smarty->assign("data",$data);
33 $html=$smarty->fetch("worldwide-list.tpl");
34 $smarty->assign("rep_office",$html);
35 unset($data);
36
37 $main=$smarty->fetch("worldwide.tpl");
38
39 ?>

  ViewVC Help
Powered by ViewVC 1.1.26