--- human_health.php 2001/02/20 12:16:35 1.1.1.1 +++ human_health.php 2001/03/05 12:01:28 1.3 @@ -46,7 +46,7 @@ if (isset($search)) { - $sth = $dbh->prepare("select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc from products $sql_where"); + $sth = $dbh->prepare("select distinct brand,form,generic,description,type,atc,town,smpc,have_smpc from products $sql_where order by brand asc"); $sth->execute(); while ($row=$sth->fetchrow_hash()) { $data[]=$row; @@ -63,7 +63,9 @@ $smarty->assign("search","all"); } -$smarty->assign("type","$type"); +$smarty->assign( array(type=>"$type", + show_description=>$show_description + )); $main=$smarty->fetch("human_health.tpl"); include("common.inc");