--- animal_health.php	2001/03/14 14:34:59	1.4
+++ animal_health.php	2001/10/01 14:05:16	1.7
@@ -8,9 +8,7 @@
 
 $section="products";
 
-$title="Products : Animal Health";
-$lpic="products"; $lext=".jpg";
-$mpic="products.gif";
+include("section.inc");
 $back_url="products.php";
 
 $sql_where=array();
@@ -60,7 +58,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%') )
 	";
 }
@@ -71,7 +69,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) {