azmicolejr

Untitled

Aug 19th, 2015
328
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. $sql = "SELECT * from kegiatan LEFT JOIN pilihan on kegiatan.id_kgt = pilihan.kdpilih ORDER BY id_kgt ASC";
  2. $result = mysqli_query($conn, $sql);
  3. $no = 1;
  4. if (mysqli_num_rows($result) > 0)
  5. {
  6. while ($data = mysqli_fetch_array($result))
  7. {
  8. echo "<tr>
  9. <td>".$data['id_kgt']."</a></td>
  10. <td>".$data['nama_kgt']."</a></td>
  11. <td>".$data['ket']."</td>
  12. <td>".tglindo($data['tg_mulai'])."</td>
  13. <td>".tglindo($data['tg_akhir'])."</td>
  14. <td>".$data['indi01'].", ".$data['indi02'].", ".$data['indi03'].", ".$data['indi04'].", ".$data['indi05'].",
  15. ".$data['indi06'].", ".$data['indi07'].", ".$data['indi08'].", ".$data['indi09'].", ".$data['indi010']."</td>
  16. <td>".$data['nm_pengirim']."</td>
  17. <td>
  18. <a href='".$data['file']."'>Download</a>
  19. <a href='kegiatan_ubah.php?id_file=$data[id_kgt]'>Ubah</a>
  20. <a href='kegiatan_hapus.php?id_file=$data[id_kgt]'>Hapus</a>
  21. </td>
  22. </tr>";
  23. $no++;
  24. }
  25. }
Advertisement
Add Comment
Please, Sign In to add comment