18 |
$sth = $dbh->prepare("select type,description from prod_type"); |
$sth = $dbh->prepare("select type,description from prod_type"); |
19 |
$sth->execute(); |
$sth->execute(); |
20 |
$types[]="any"; |
$types[]="any"; |
21 |
|
$type_desc[]="any"; |
22 |
while ($row=$sth->fetchrow_array()) { |
while ($row=$sth->fetchrow_array()) { |
23 |
$types[]=$row[0]; |
$types[]=$row[0]; |
24 |
$type_desc[]=$row[1]; |
$type_desc[]=$row[1]; |
51 |
|
|
52 |
if (isset($search)) { |
if (isset($search)) { |
53 |
|
|
54 |
$sth = $dbh->prepare("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"; |
55 |
|
$sth = $dbh->prepare("$sql"); |
56 |
$sth->execute(); |
$sth->execute(); |
57 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
58 |
$data[]=$row; |
$data[]=$row; |
75 |
$main=$smarty->fetch("human_health.tpl"); |
$main=$smarty->fetch("human_health.tpl"); |
76 |
|
|
77 |
include("common.inc"); |
include("common.inc"); |
78 |
$smarty->assign( array(back_url=>$back_url, MAIN=>$main)); |
$smarty->assign( array(back_url=>$back_url, MAIN=>$main, self=>$PHP_SELF)); |
79 |
|
|
80 |
$smarty->display("index.tpl"); |
$smarty->display("index.tpl"); |
81 |
?> |
?> |