--- animal_health.php	2001/03/05 14:30:46	1.3
+++ animal_health.php	2001/03/14 14:34:59	1.4
@@ -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 distinct vet_animal_product.animal,name from vet_animal_product,vet_animal where vet_animal_product.animal=vet_animal.animal and smpc=$row[smpc]");
 			$sth2->execute();
 			unset($animals);
 			while ($row2=$sth2->fetchrow_hash()) {