<?php
				    include("config/connection.php");
					$penumpang = $_GET['penumpang'];
					$idjadwal = $_GET['idjadwal'];

              		$sql ="select tb_jadwal.'$penumpang'
							from tb_jadwal inner join tb_kapal on tb_jadwal.Id_Kapal = tb_kapal.Id_Kapal
							inner join tb_nahkoda on tb_jadwal.Id_Nahkoda = tb_nahkoda.Id_Nahkoda
							inner join tb_pelabuhan pDari on (pDari.Id_Pelabuhan = tb_jadwal.Dari)
							inner join tb_pelabuhan pTujuan on (pTujuan.Id_Pelabuhan = tb_jadwal.Tujuan)
							inner join tb_jenis_kapal on tb_kapal.Id_Jenis = tb_jenis_kapal.Id
							where tb_jadwal.Status = '1' and tb_jadwal.Id_Jadwal = '".$idjadwal."'";
					$hasil = mysql_query($sql) or die("Kesalahan Pada SQL");
					mysql_close($test);
					
					$row = mysql_fetch_object($hasil);
						$id = $row->Id_Jadwal;
						$namakapal = $row->namakapal;
						$Nahkoda = $row->Nahkoda;
						$dari = $row->dari;
						$tujuan = $row->tujuan;
						$Kuota_Order = $row->Kuota_Order;
						$Sisa = $row->Sisa;
						$tanggal = $row->tgl;
						$Waktu = $row->Waktu;
						$Jenis = $row->Jenis;
						
						$dewasa = $row->dewasa;
						$anak = $row->anak;
						$gol_1 = $row->gol_1;
						$gol_2 = $row->gol_2;
						$gol_3 = $row->gol_3;
						$gol_4a = $row->gol_4a;
						$gol_4b = $row->gol_4b;
						$gol_5a = $row->gol_5a;
						$gol_5b = $row->gol_5b;
						$gol_6a = $row->gol_6a;
						$gol_6b = $row->gol_6b;

echo "<option value=''>- Pilih Kelurahan -</option>";
while($k = mysql_fetch_array($sql2)){
    echo "<option value=\"".$k['id_kelurahan']."\">".$k['nama_kelurahan']."</option>\n";
}
?>
