<?
$data = $_GET['data'];
$val = $_GET['val'];
$rang = $_GET['rang'];

include('connection.php');

if ($data=='hoofditem') {  // first dropdown
  echo "<select name='hoofditem' onChange=\"dochange('submenu', this.value)\">\n";
  echo "<option value='0'>-- Kies een Optie --</option>\n";
  $query = "SELECT * FROM exercisemenu";
  $result = mysql_query($query);
  while($row = mysql_fetch_array($result)){
       echo "<option value=\"{$row['id']}\" >{$row['naam']}</option> \n" ;
  }
} else if ($data=='submenu') { // second dropdown
  echo "<select name='submenu' onChange=\"dochange('subsubmenu', this.value)\">\n";
  echo "<option value='0'>-- Kies een Optie --</option>\n";
  $query = "SELECT * FROM submenu WHERE menurang='$val'";
  $result = mysql_query($query);
  while($row = mysql_fetch_array($result)){
       echo "<option value=\"{$row['id']}\" >{$row['menuText']}</option> \n" ;
  }
}
else if($data == 'subsubmenu')
{
  echo "<select name='subsubmenu' >\n";
  echo "<option value='0'>-- Kies een Optie --</option>\n";
  $query = "SELECT * FROM submenutxt WHERE submenu='$val'";
  $result = mysql_query($query);
  while($row = mysql_fetch_array($result)){
       echo "<option value=\"{$row['id']}\" >{$row['text']}</option> \n" ;
  }
}
echo $val;
echo "</select>\n";
?>