--- animal_health.php	2001/03/03 12:55:31	1.1
+++ animal_health.php	2001/03/05 12:01:28	1.2
@@ -75,7 +75,7 @@
 	$sth->execute();
 	while ($row=$sth->fetchrow_hash()) {
 		if ($show_animals) {
-			$sth2 = $dbh->prepare("select vet_animal_product.animal,name from vet_animal_product,vet_animal where vet_animal_product.animal=vet_animal.animal and smpc=$row[smpc]");
+			$sth2 = $dbh->prepare("select vet_animal_product.animal,name from vet_animal_product,vet_animal where vet_animal_product.animal=vet_animal.animal and smpc=$row[smpc] order by brand asc");
 			$sth2->execute();
 			unset($animals);
 			while ($row2=$sth2->fetchrow_hash()) {