// db meros //

CREATE TABLE `auto` (
  `id` int(4) NOT NULL,
  `company` varchar(12) NOT NULL,
  `model` varchar(12) NOT NULL,
  `color` varchar(12) NOT NULL,
  `fuel` varchar(12) NOT NULL,
  `year` int(4) NOT NULL,
  `price` int(7) NOT NULL
)


// FORM meros //

<form method="post" action="search.php">
 
  <select name="search"> 
  <option value="">""</option> 
  <option value="fiat">fiat</option>
   <option value="hunday">hunday</option> 
   <option value="reno">reno</option> 
   <option value="toyota">toyota</option> 
   <option value="skoda">skoda</option> 
   <option value="audi">audi</option>
    </select> 
    
    <input type="text" name="search2" size=25 maxlength=25>
    
    <select name="search3"> 
  <option value="">""</option> 
  <option value="diesel">diesel</option>
   <option value="benzin">benzin</option> 
    </select> 
    
    <input type="Submit" name="Submit" value="Submit"> </form>

// PHP meros //

<?

mysql_connect("localhost","nn","nnn"); 
    

mysql_select_db("amaxadiko");

$search=$_POST['search'];
$search2=$_POST['search2'];
$search3=$_POST['search3'];


$result = mysql_query("SELECT * FROM auto WHERE company = '$search' AND model = '$search2' AND fuel = '$search3'");

$numRows = mysql_num_rows($result);

if( $numRows == "0" ){


echo "No Results Found";

} else {

while($r=mysql_fetch_array($result))
{    
  
   $company=$r['company'];
   $model=$r['model'];
   $price=$r['price'];
   $fuel=$r['fuel'];
      
   
 
   echo " Znacka: $company<br>  Model: $model<br> Cena: $price<br> Fuel: $fuel<br> <p>";
}

} 

?>