Hello,

I did a tutorial on a website to make a chained dropdown and I almost finished it...

This is my index.php:

PHP Code:
<?php 
  
include('db.php');
  include(
'func.php');
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Chained Select Boxes using PHP, MySQL and jQuery</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {
    $('#wait_1').hide();
    $('#drop_1').change(function(){
      $('#wait_1').show();
      $('#result_1').hide();
      $.get("func.php", {
        func: "drop_1",
        drop_var: $('#drop_1').val()
      }, function(response){
        $('#result_1').fadeOut();
        setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
      });
        return false;
    });
    $('#wait_2').hide();
    $('#drop_2').change(function(){
      $('#wait_2').show();
      $('#result_2').hide();
      $.get("func.php", {
        func: "drop_2",
        drop_var: $('#drop_2').val()
      }, function(response){
        $('#result_2').fadeOut();
        setTimeout("finishAjax2('result_2', '"+escape(response)+"')", 400);
      });
        return false;
    });
});

function finishAjax(id, response) {
  $('#wait_1').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
function finishAjax2(id, response) {
  $('#wait_2').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}

function finishAjax_tier_three(id, response) {
  $('#wait_2').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
function finishAjax_tier_four(id, response) {
  $('#wait_3').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
</script>
</head>

<body>
<p>
<form action="" method="post">
  
    <select name="drop_1" id="drop_1">
    
      <option value="" selected="selected" disabled="disabled">Selecteer Merk</option>
      
      <?php getTierOne(); ?>
    
    </select> 
    
    <span id="wait_1" style="display: none;">
    <img alt="Please Wait" src="ajax-loader.gif"/>
    </span>
    <span id="result_1" style="display: none;"></span>
    <span id="wait_2" style="display: none;">
    <img alt="Please Wait" src="ajax-loader.gif"/>
    </span>
    <span id="result_2" style="display: none;"></span> 
    <span id="wait_3" style="display: none;">
    <img alt="Please Wait" src="ajax-loader.gif"/>
    </span>
    <span id="result_3" style="display: none;"></span> 
  
</form>
</p>
<p>
<?php if(isset($_POST['submit'])){
    
$drop $_POST['drop_1'];
    
$drop_2 $_POST['drop_2'];
    
$drop_3 $_POST['drop_3'];
    
$drop_4 $_POST['drop_4'];
    echo 
"U heeft een ";
    echo 
$drop." ".$drop_2." geselecteerd uit ".$drop_3." en u heeft daar deze accu voor nodig ".$drop_4;
}
?>
</body>
</html>
And this is my func.php

PHP Code:
<?php
//**************************************
//     Page load dropdown results     //
//**************************************
function getTierOne()
{
    
$result mysql_query("SELECT DISTINCT make FROM vehicles ORDER BY make ASC"
    or die(
mysql_error());

      while(
$tier mysql_fetch_array$result )) 
  
        {
           echo 
'<option value="'.$tier['make'].'">'.$tier['make'].'</option>';
        }

}

//**************************************
//     First selection results     //
//**************************************
if (isset($_GET['func'])&& $_GET['func'] == "drop_1" ) {
drop_1($_GET['drop_var']);
}

function 
drop_1($drop_var)
{  
    include_once(
'db.php');
    
$result mysql_query("SELECT DISTINCT model FROM vehicles WHERE make='$drop_var' ORDER BY model"
    or die(
mysql_error());
    
    echo 
'<select name="drop_2" id="drop_2">
          <option value=" " disabled="disabled" selected="selected">Selecteer Model</option>'
;

           while(
$drop_2 mysql_fetch_array$result )) 
            {
              echo 
'<option value="'.$drop_2['model'].'">'.$drop_2['model'].'</option>';
            }
    
    echo 
'</select>';
    echo 
"<script type=\"text/javascript\">
$('#wait_2').hide();
    $('#drop_2').change(function(){
      $('#wait_2').show();
      $('#result_2').hide();
      $.get(\"func.php\", {
        func: \"drop_2\",
        drop_var: $('#drop_2').val()
      }, function(response){
        $('#result_2').fadeOut();
        setTimeout(\"finishAjax_tier_three('result_2', '\"+escape(response)+\"')\", 400);
      });
        return false;
    });
</script>"
;
}

//**************************************
//     Second selection results     //
//**************************************
if (isset($_GET['func'])&& $_GET['func'] == "drop_2" ) {
drop_2($_GET['drop_var']);
}

function 
drop_2($drop_var2)
{  
    include_once(
'db.php');
    
$result mysql_query("SELECT DISTINCT year FROM vehicles WHERE model='$drop_var2'"
    or die(
mysql_error());
    
    echo 
'<select name="drop_3" id="drop_3">
          <option value=" " disabled="disabled" selected="selected">Selecteer Jaar</option>'
;

           while(
$drop_3 mysql_fetch_array$result )) 
            {
              echo 
'<option value="'.$drop_3['year'].'">'.$drop_3['year'].'</option>';
            }
    
    echo 
'</select>';
    echo 
"<script type=\"text/javascript\">
$('#wait_3').hide();
    $('#drop_3').change(function(){
      $('#wait_3').show();
      $('#result_3').hide();
      $.get(\"func.php\", {
        func: \"drop_3\",
        drop_var: $('#drop_3').val()
      }, function(response){
        $('#result_3').fadeOut();
        setTimeout(\"finishAjax_tier_four('result_3', '\"+escape(response)+\"')\", 400);
      });
        return false;
    });
</script>"
;
}

//**************************************
//     Second selection results     //
//**************************************
if(isset($_GET['func'])&& $_GET['func'] == "drop_3" ) {
drop_3($_GET['drop_var']);
}
function 
drop_3($drop_var3)
{  
    include_once(
'db.php');
        
$result mysql_query("SELECT * FROM vehicles WHERE year='$drop_var3'"
    or die(
mysql_error());
    
    echo 
'<select name="drop_4" id="drop_4">
          <option value="" disabled="disabled" selected="selected">Selecteer Accu</option>'
;


           while(
$drop_4 mysql_fetch_array$result )) 
                {
                if (
$drop_4['accu'] != "") {
              echo 
'<option value="'.$drop_4['accu'].'">'.$drop_4['accu'].'</option>';
                }
  }
    echo 
'</select> ';
    echo 
'<input type="submit" name="submit" value="Submit" />';
}

?>
I have a database vehicles with "id", "make", "model", "year" and "accu"

It is working correct but in the last dropdown "accu" it is showing all the accu's from the selected "year" and I want only one accu that matches the other selections... for example

Volvo - XC90 - 2013 - and the accu belong to all fields..

How do I have to change my last function to make that work?

I allready tried this but that did not work:

PHP Code:
function drop_3($drop_var$drop_var2$drop_var3)
{  
    include_once(
'db.php');
        
$result mysql_query("SELECT * FROM vehicles WHERE make='$drop_var' AND model='$drop_var2' AND year='$drop_var3'"
    or die(
mysql_error()); 
Can somebody help me out?

Thanks in advance