Parent Directory | Revision Log | Patch
revision 1.5 by dpavlin, Fri Mar 16 08:54:06 2001 UTC | revision 1.7 by dpavlin, Mon Oct 1 14:05:16 2001 UTC | |
---|---|---|
# | Line 8 $smarty->assign( array ( Title=>"Pliva d | Line 8 $smarty->assign( array ( Title=>"Pliva d |
8 | ||
9 | $section="products"; | $section="products"; |
10 | ||
11 | $title="Products : Animal Health"; | include("section.inc"); |
$lpic="products"; $lext=".jpg"; | ||
$mpic="products.gif"; | ||
12 | $back_url="products.php"; | $back_url="products.php"; |
13 | ||
14 | $sql_where=array(); | $sql_where=array(); |
# | Line 71 if ($sql_where) { | Line 69 if ($sql_where) { |
69 | ||
70 | if (isset($search)) { | if (isset($search)) { |
71 | ||
72 | $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"); |
73 | $sth->execute(); | $sth->execute(); |
74 | while ($row=$sth->fetchrow_hash()) { | while ($row=$sth->fetchrow_hash()) { |
75 | if ($show_animals) { | if ($show_animals) { |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |