Parent Directory | Revision Log | Patch
revision 1.4 by dpavlin, Mon Mar 5 13:03:45 2001 UTC | revision 1.5 by dpavlin, Tue Mar 6 07:38:45 2001 UTC | |
---|---|---|
# | Line 18 $smarty->assign( array ( lpic=>$lpic, le | Line 18 $smarty->assign( array ( lpic=>$lpic, le |
18 | $sth = $dbh->prepare("select type,description from prod_type"); | $sth = $dbh->prepare("select type,description from prod_type"); |
19 | $sth->execute(); | $sth->execute(); |
20 | $types[]="any"; | $types[]="any"; |
21 | $type_desc[]="any"; | |
22 | while ($row=$sth->fetchrow_array()) { | while ($row=$sth->fetchrow_array()) { |
23 | $types[]=$row[0]; | $types[]=$row[0]; |
24 | $type_desc[]=$row[1]; | $type_desc[]=$row[1]; |
# | Line 50 if ($sql_where != "") { | Line 51 if ($sql_where != "") { |
51 | ||
52 | if (isset($search)) { | if (isset($search)) { |
53 | ||
54 | $sth = $dbh->prepare("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 from products $sql_where order by brand asc"; |
55 | $sth = $dbh->prepare("$sql"); | |
56 | $sth->execute(); | $sth->execute(); |
57 | while ($row=$sth->fetchrow_hash()) { | while ($row=$sth->fetchrow_hash()) { |
58 | $data[]=$row; | $data[]=$row; |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |