/[corp_html]/animal_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 /animal_health.php

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

revision 1.4 by dpavlin, Wed Mar 14 14:34:59 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 60  if (isset($type) && $type!="any") { Line 58  if (isset($type) && $type!="any") {
58  if (isset($search) && $search!="" && $search!="all") {  if (isset($search) && $search!="" && $search!="all") {
59          $sql_where[]=" (upper(brand) like upper('%$search%') or          $sql_where[]=" (upper(brand) like upper('%$search%') or
60          upper(form) like upper('%$search%') or          upper(form) like upper('%$search%') or
61          upper(generic) like upper('%$search%') or          upper(composition) like upper('%$search%') or
62          upper(description) like upper('%$search%') )          upper(description) like upper('%$search%') )
63          ";          ";
64  }  }
# 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) {
Legend:
Removed from v.1.4  
changed lines
  Added in v.1.7
  ViewVC Help
Powered by ViewVC 1.1.26