<script type="text/javascript">
<!-- <![CDATA[
  
function szukaj(formularz) {
   plik = "szukaj.php?q="+formularz.q.value;
    //plik2 = "szukaj.php?qq="+formularz.qq.value;
    
   element = document.getElementById("wynik");
  
   xml = null;
   element.innerHTML="";
  
   if (window.XMLHttpRequest) { // Mozilla, Safari, Opera ...
     xml = new XMLHttpRequest();
} else if (window.ActiveXObject) { // IE
     xml = new ActiveXObject("Microsoft.XMLHTTP");
}

   if (xml != null) {
     xml.onreadystatechange = function() {
       if (xml.readyState==4) {
         element.innerHTML=xml.responseText;
       }
     }
     xml.open("GET", plik, true);
     //xml.open("GET", plik2, true);
     xml.send(null);
   }
   return false;
}
// ]]> -->//
</script>
  
<form action="index.php" method="get" onsubmit="return szukaj(this)"><div>
     <!--<input type="text" name="q" />    -->
  
  <select name="q"  >
         <option selected="selected">wybierz</option>
         <option >NEUMEIER</option>
         <option >JCB</option>
         <option >CAT</option>
         <option >HANOMAG</option>
         <option >CUKUROVA</option>
         <option >KUBOTA</option>
         <option >SANDERSON</option>
         <option >LIEBHERR</option>
         <option >FADROMA</option>
         <option >NEW HOLLAND</option>
         </select>
        
      <select name="qq"  >    
<option selected="selected">wybierz</option>
         <option >kopraka</option>
         <option >koparko-ładowarka</option>
         <option >ładowarka</option>
         <option >minikoparka</option>
         <option >walec</option>
         <option >równiarka</option>
        
         </select>


<input type="submit" value="filtruj" />
</div></form>
<div id="wynik"></div>

<?

$q = $_GET["q"];
  if (get_magic_quotes_gpc()) $q = stripslashes($q);
$q = trim(htmlspecialchars($q, ENT_QUOTES));
  $db_handle = pg_connect("dbname = db user=login password=haslo host=host");
//if (p$db_handle)
  

$query = "Select * from maszyny where  marka='$q' or typ='$qq'    order by lp_maszyny "; //typ LIKE '%$q%'     marka='$q'
$wynik = pg_exec ($db_handle, $query);

   //$wynik = mysql_query("
     //SELECT * FROM $sql_tabela WHERE login LIKE '%$q%'

  
  


if ($wynik and pg_numrows($wynik)<1 )
{
echo "<p>Brak danych</p>"; //$wynik and pg_numrows($wynik)<1
}
else
{
$n = pg_numrows($wynik);
echo "<p>dane: $n </p>";
for($row=0; $row< pg_numrows($wynik); $row++){
$dane = pg_fetch_array($wynik, $lp_maszyny);

echo '<a href="/admin/im_maszyny/'.$dane["lp_maszyny"].'.jpg " target="_blank" width="640" height="480" >
<img src="/admin/im_maszyny/'.$dane["lp_maszyny"].'.jpg " width="150" height="150"/></a>';

}

}
  pg_close();
?>