--- human_health.php	2001/03/03 09:27:38	1.2
+++ human_health.php	2001/03/05 12:01:28	1.3
@@ -46,7 +46,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;