Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $result = $koneksi->query("SELECT tb_sekolah.idSekolah, tb_sekolah.namaSekolah, tb_sekolah.tb_kategori_sekolah_idKategori, tb_kategori_sekolah.namaKategori, tb_uptd.namaUPTD, tb_sekolah.alamat, tb_sekolah.telp, tb_sekolah.kataSandi, tb_sekolah.status
- FROM tb_sekolah, tb_kategori_sekolah, tb_uptd
- WHERE tb_sekolah.tb_kategori_sekolah_idKategori = tb_kategori_sekolah.idKategori
- AND tb_uptd.idUPTD = tb_sekolah.tb_UPTD_idUPTD
- AND idSekolah='$id'");
- while ($row = $result->fetch_array()){
- <select name="id_kategori" size="1" class="form-control" required>
- <option label="-- Pilih Kategori --" ></option>
- <?php //looping kategori
- $result1 = $koneksi->query("SELECT * FROM tb_kategori_sekolah");
- while ($row1 = $result1->fetch_array()){
- if ($row['tb_kategori_sekolah_idKategori']==$row1['idKategori']){
- $status = 'selected' ;
- } ?>
- <option <?php echo isset($status)?$status:''; ?> value="<?php echo $row1['idKategori'] ?>"><?php echo $row1['namaKategori']; ?></option>
- <?php } ?>
- </select>
- <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement