Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $sql="
- SELECT
- j1.nama_jaksa nama_jaksa1, j2.nama_jaksa nama_jaksa2
- from rp6
- left join tbl_kategori on rp6.id_kategori=tbl_kategori.id_kategori
- join tbl_tersangka on rp6.id_tersangka=tbl_tersangka.id_tersangka
- join tbl_jaksa j1 on rp6.id_jaksa1 = j1.id_jaksa
- join tbl_jaksa j2 on rp6.id_jaksa2 = j2.id_jaksa
- ";
- $e = $this->db->query($sql)->row_array();
- ?>
- <div class='form-group'> Jaksa 1
- <input type="text" class="form-control" name="jaksa1"
- id="jaksa1" placeholder="jaksa1" value="<?php echo $e['nama_jaksa1']; ?>" />
- </div>
- <div class='form-group'> Jaksa 2
- <input type="text" class="form-control" name="jaksa2"
- id="jaksa2" placeholder="jaksa2" value="<?php echo $e['nama_jaksa2']; ?>" />
- </div>
Advertisement
Add Comment
Please, Sign In to add comment