--- human_health.php 2001/03/06 07:38:45 1.5 +++ human_health.php 2001/03/12 16:41:56 1.6 @@ -51,7 +51,7 @@ if (isset($search)) { - $sql="select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc from products $sql_where order by brand asc"; + $sql="select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc,tm from products $sql_where order by brand asc"; $sth = $dbh->prepare("$sql"); $sth->execute(); while ($row=$sth->fetchrow_hash()) {