Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $server = "localhost";
- $user = "root";
- $pass = "";
- $db = "login";
- $database = new mysqli($server, $user, $pass, $db);
- /*********************************************************/
- $option = '<option value=""> - Data leased Line - </option>';
- $jk = isset($_GET['jk']) ? $_GET['jk'] :'';
- $sql = "SELECT id_sm,id_pekerjaan,nm_sm,nm_pekerjaan FROM `tswisma` INNER join pekerjaan on tswisma.id_sm=pekerjaan.id_sm where id_sm='".$jk."'";
- if($res = $database->query($sql)) {
- while ($row = $res->fetch_assoc()) {
- $option .= "<option value='".$row['id_pekerjaan']."'>".$row['nm_pekerjaan']."</option>";
- }
- }
- echo $option;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement