46 |
|
|
47 |
if (isset($search)) { |
if (isset($search)) { |
48 |
|
|
49 |
$sth = $dbh->prepare("select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc from products $sql_where"); |
$sth = $dbh->prepare("select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc from products $sql_where order by brand asc"); |
50 |
$sth->execute(); |
$sth->execute(); |
51 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
52 |
$data[]=$row; |
$data[]=$row; |
63 |
$smarty->assign("search","all"); |
$smarty->assign("search","all"); |
64 |
} |
} |
65 |
|
|
66 |
$smarty->assign("type","$type"); |
$smarty->assign( array(type=>"$type", |
67 |
|
show_description=>$show_description |
68 |
|
)); |
69 |
$main=$smarty->fetch("human_health.tpl"); |
$main=$smarty->fetch("human_health.tpl"); |
70 |
|
|
71 |
include("common.inc"); |
include("common.inc"); |