--- animal_health.php 2001/03/16 08:54:06 1.5 +++ animal_health.php 2001/04/05 12:26:33 1.6 @@ -71,7 +71,7 @@ if (isset($search)) { - $sth = $dbh->prepare("select distinct brand,form,composition,description,type,smpc from vet_products $sql_where order by brand asc"); + $sth = $dbh->prepare("select distinct brand,form,composition,description,type,smpc,have_smpc from vet_products $sql_where order by brand asc"); $sth->execute(); while ($row=$sth->fetchrow_hash()) { if ($show_animals) {