--- human_health.php 2001/03/05 12:01:28 1.3 +++ human_health.php 2001/03/05 13:03:45 1.4 @@ -15,13 +15,17 @@ $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) ); -$sth = $dbh->prepare("select distinct type from products"); +$sth = $dbh->prepare("select type,description from prod_type"); $sth->execute(); $types[]="any"; while ($row=$sth->fetchrow_array()) { $types[]=$row[0]; + $type_desc[]=$row[1]; } -$smarty->assign("types",$types); +$smarty->assign(array( + types=>$types, + type_desc=>$type_desc + )); $sql_where="";