--- animal_health.php	2001/03/05 14:30:46	1.3
+++ animal_health.php	2001/03/16 08:54:06	1.5
@@ -60,7 +60,7 @@
 if (isset($search) && $search!="" && $search!="all") {
 	$sql_where[]=" (upper(brand) like upper('%$search%') or
 	upper(form) like upper('%$search%') or
-	upper(generic) like upper('%$search%') or
+	upper(composition) like upper('%$search%') or
 	upper(description) like upper('%$search%') )
 	";
 }
@@ -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()) {