/[corp_html]/human_health.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /human_health.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.3 by dpavlin, Mon Mar 5 12:01:28 2001 UTC revision 1.5 by dpavlin, Tue Mar 6 07:38:45 2001 UTC
# Line 15  $back_url="products.php"; Line 15  $back_url="products.php";
15    
16  $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) );  $smarty->assign( array ( lpic=>$lpic, lext=>$lext, mpic=>$mpic, Section_title=>$title ) );
17    
18  $sth = $dbh->prepare("select distinct type from products");  $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];
25  }  }
26  $smarty->assign("types",$types);  $smarty->assign(array(
27            types=>$types,
28            type_desc=>$type_desc
29            ));
30    
31  $sql_where="";  $sql_where="";
32    
# Line 46  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;
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.5
  ViewVC Help
Powered by ViewVC 1.1.26