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 |