Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "SELECT * from kegiatan LEFT JOIN pilihan on kegiatan.id_kgt = pilihan.kdpilih ORDER BY id_kgt ASC";
- $result = mysqli_query($conn, $sql);
- $no = 1;
- if (mysqli_num_rows($result) > 0)
- {
- while ($data = mysqli_fetch_array($result))
- {
- echo "<tr>
- <td>".$data['id_kgt']."</a></td>
- <td>".$data['nama_kgt']."</a></td>
- <td>".$data['ket']."</td>
- <td>".tglindo($data['tg_mulai'])."</td>
- <td>".tglindo($data['tg_akhir'])."</td>
- <td>".$data['indi01'].", ".$data['indi02'].", ".$data['indi03'].", ".$data['indi04'].", ".$data['indi05'].",
- ".$data['indi06'].", ".$data['indi07'].", ".$data['indi08'].", ".$data['indi09'].", ".$data['indi010']."</td>
- <td>".$data['nm_pengirim']."</td>
- <td>
- <a href='".$data['file']."'>Download</a>
- <a href='kegiatan_ubah.php?id_file=$data[id_kgt]'>Ubah</a>
- <a href='kegiatan_hapus.php?id_file=$data[id_kgt]'>Hapus</a>
- </td>
- </tr>";
- $no++;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment