--- human_health.php	2001/02/20 12:16:35	1.1
+++ human_health.php	2001/03/05 13:03:45	1.4
@@ -15,13 +15,17 @@
 
 $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) );
 
-$sth = $dbh->prepare("select distinct type from products");
+$sth = $dbh->prepare("select type,description from prod_type");
 $sth->execute();
 $types[]="any";
 while ($row=$sth->fetchrow_array()) {
 	$types[]=$row[0];
+	$type_desc[]=$row[1];
 }
-$smarty->assign("types",$types);
+$smarty->assign(array(
+	types=>$types,
+	type_desc=>$type_desc
+	));
 
 $sql_where="";
 
@@ -46,7 +50,7 @@
 
 if (isset($search)) {
 
-	$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");
 	$sth->execute();
 	while ($row=$sth->fetchrow_hash()) {
 		$data[]=$row;
@@ -63,7 +67,9 @@
 	$smarty->assign("search","all");
 }
 
-$smarty->assign("type","$type");
+$smarty->assign( array(type=>"$type",
+		show_description=>$show_description
+	));
 $main=$smarty->fetch("human_health.tpl");
 
 include("common.inc");