--- human_health.php	2001/03/05 13:03:45	1.4
+++ human_health.php	2001/03/06 07:38:45	1.5
@@ -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 from products $sql_where order by brand asc";
+	$sth = $dbh->prepare("$sql");
 	$sth->execute();
 	while ($row=$sth->fetchrow_hash()) {
 		$data[]=$row;