<div class="row">

  <div class="col-12">

    <select class="mdb-select md-form md-selected colorful-select dropdown-primary" searchable="Suche" name="oertlichkeit" onchange="fetch_select(this.value);" required>

      <option></option>

      <option>Alterssiedlung</option>

      <option>Asylunterkunft</option>

      <option>Brücke</option>

    </select>

    <label class="mdb-main-label">Örtlichkeit *</label>

  </div>

</div>

​

<div class="row">

  <div class="col-12">

    <select class="mdb-select md-form md-selected colorful-select dropdown-primary" searchable="Suche" name="ort" id="ort" required>

      <option></option>

    </select>

    <label class="mdb-main-label">Ort *</label>

  </div>

</div>

​

​

<?php

//This is my dydropdown_data.php

if(isset($_POST['get_option']))

{

require'inc/db_connect.php';

​

$oertlichkeit = $_POST['get_option'];  

$tabelle = "";

if($oertlichkeit == "Alterssiedlung")

{

    $tabelle = "tbl_alterssiedlungen";

}elseif($oertlichkeit == "Asylunterkunft")

{

     $tabelle = "tbl_asylunterkuenfte";

}elseif($oertlichkeit == "Brücke")

{

    $tabelle = "tbl_bruecken";

}

 $sql="SELECT * FROM $tabelle";

// Leere Option ermöglichen bei Auswahlfeld

foreach ($conn->query($sql) as $row) 

{

    echo "<option>".$row['Name']."</option>";

}

 exit;

}

?>