6 |
|
|
7 |
$smarty->assign( array ( Title=>"Pliva d.d." ) ); |
$smarty->assign( array ( Title=>"Pliva d.d." ) ); |
8 |
|
|
9 |
$section="products"; |
include("section.inc"); |
|
|
|
|
$title="Products : Human Health"; |
|
|
$lpic="products"; $lext=".jpg"; |
|
|
$mpic="products.gif"; |
|
10 |
$back_url="products.php"; |
$back_url="products.php"; |
11 |
|
|
12 |
$smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); |
$smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); |
47 |
|
|
48 |
if (isset($search)) { |
if (isset($search)) { |
49 |
|
|
50 |
$sql="select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc from products $sql_where order by brand asc"; |
$sql="select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc,tm from products $sql_where order by brand asc"; |
51 |
$sth = $dbh->prepare("$sql"); |
$sth = $dbh->prepare("$sql"); |
52 |
$sth->execute(); |
$sth->execute(); |
53 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
71 |
$main=$smarty->fetch("human_health.tpl"); |
$main=$smarty->fetch("human_health.tpl"); |
72 |
|
|
73 |
include("common.inc"); |
include("common.inc"); |
74 |
$smarty->assign( array(back_url=>$back_url, MAIN=>$main)); |
$smarty->assign( array(back_url=>$back_url, MAIN=>$main, self=>$PHP_SELF)); |
75 |
|
|
76 |
$smarty->display("index.tpl"); |
$smarty->display("index.tpl"); |
77 |
?> |
?> |