Coding untuk menampilkan data tabel serta select di php dan mysql

 <tr>

        <td>Agama </td>

        <td>

          <?php

          include "../kalakay/resto_conn.php";

          $query = "SELECT * FROM agama ORDER BY 'id_agama' DESC";

          $data_agama = mysqli_query($koneksi, $query);

        ?>

        <select id="id" type="text" class="form-control" name="id_agama" onchange="changeValueId(this.value)">

          <option>

          <?php

          $dataagama = $edit_mahasiswa["id_agama"];

          $query=mysqli_query($koneksi, "SELECT * FROM agama WHERE id_agama ='$dataagama' ORDER BY id_agama");

          $tampil_agama=mysqli_fetch_array($query); ?>

          <?php echo $tampil_agama['nm_agama']; ?> 

          </option>

          <?php while( $dataku = mysqli_fetch_assoc($data_agama)) : ?>

            <option value="<?=$dataku['id_agama']?>">  

            <?php echo $dataku['nm_agama']?>

            </option>

          <?php endwhile ?>

         </select>

          <br>

        </td>

      </tr>