Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2016
206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. $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
  2. FROM tb_sekolah, tb_kategori_sekolah, tb_uptd
  3. WHERE tb_sekolah.tb_kategori_sekolah_idKategori = tb_kategori_sekolah.idKategori
  4. AND tb_uptd.idUPTD = tb_sekolah.tb_UPTD_idUPTD
  5. AND idSekolah='$id'");
  6.  
  7. while ($row = $result->fetch_array()){
  8.  
  9. <select name="id_kategori" size="1" class="form-control" required>
  10. <option label="-- Pilih Kategori --" ></option>
  11. <?php //looping kategori
  12. $result1 = $koneksi->query("SELECT * FROM tb_kategori_sekolah");
  13. while ($row1 = $result1->fetch_array()){
  14. if ($row['tb_kategori_sekolah_idKategori']==$row1['idKategori']){
  15. $status = 'selected' ;
  16. } ?>
  17. <option <?php echo isset($status)?$status:''; ?> value="<?php echo $row1['idKategori'] ?>"><?php echo $row1['namaKategori']; ?></option>
  18. <?php } ?>
  19. </select>
  20. <?php } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement