--- human_health.php	2001/03/05 13:03:45	1.4
+++ human_health.php	2001/03/12 23:41:49	1.7
@@ -18,6 +18,7 @@
 $sth = $dbh->prepare("select type,description from prod_type");
 $sth->execute();
 $types[]="any";
+$type_desc[]="any";
 while ($row=$sth->fetchrow_array()) {
 	$types[]=$row[0];
 	$type_desc[]=$row[1];
@@ -50,7 +51,8 @@
 
 if (isset($search)) {
 
-	$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";
+	$sth = $dbh->prepare("$sql");
 	$sth->execute();
 	while ($row=$sth->fetchrow_hash()) {
 		$data[]=$row;
@@ -73,7 +75,7 @@
 $main=$smarty->fetch("human_health.tpl");
 
 include("common.inc");
-$smarty->assign( array(back_url=>$back_url, MAIN=>$main));
+$smarty->assign( array(back_url=>$back_url, MAIN=>$main, self=>$PHP_SELF));
 
 $smarty->display("index.tpl");
 ?>