Untitled

<?
include "../../_lib/function/db_nosession.php";

$sql = "select * from v_bandara_prop where id_dc_propinsi=$id_dc_propinsi";
$hasil =& $db->Execute($sql);
//$no = $hasil->fields["no"];
$nama_propinsi = $hasil->fields["nama_propinsi"];
var_dump($hasil->fetchrow());
?>
<html>
<head>
	<title>ANT WINDOWS</title>
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
	<link href="../_css/main.css" rel="stylesheet" type="text/css"/>
</head>

<body>

<table cellpadding="0" cellspacing="0" border="0" height="100%" width="100%" style="background:url('../_images/indonesia_back.png') no-repeat top left;">
	<tr>
	<td valign="middle" align="center">

	<table width="800" border="0" cellspacing="0" cellpadding="0">
		<tr>
			<td align="center"><img src="../_images/text_ant.gif" style="margin-bottom:20px;"></td>
		</tr>
		<tr>
			<td>
				<? include "../../_inc/home_portal.php"; ?>
			</td>
		</tr>
		<tr>
			<td>
				<div class="text_judul" align="center" valign="bottom">
					<?	echo $nama_propinsi; ?>
				</div>
			</td>
		</tr>
		<tr>
			<td>
				<table border="1" cellspacing="1" cellpadding="3">
					<tr>
						<td>
							<? include "../../_inc/tpl_propinsi.php"; ?>
						</td>
						<td height="200" valign="top">
										<div class="text">
											Klik Nama Bandara Untuk Melihat Jadwal Penerbangan
										</div>
									<table width="750" border="1" cellpadding="0" cellspacing="0" >
										<thead>
										<tr>
										<td>
											<div class="field" align="center">
												No.
											</div>
										</td>
										<td>
											<div class="field" align="center">
												Nama Bandara
											</div>
										</td>
										<td>
											<div class="field" align="center">
												Alamat Bandara
											</div>
										</td>
										<td>
											<div class="field" align="center">
												Jenis Bandara
											</div>
										</td>
										<td>
											<div class="field" align="center">
												Operator
											</div>
										</td>
										</tr>
										</thead>
										<tbody>
										<?
											$i=0;
											while($tampil=$hasil->fetchrow()){
											$i++;
											$nama_bandara = $tampil["nama_bandara"];
											$alamat = $tampil["alamat_bandara"];
											$jenis	= $tampil["jenis_bandara"];
											$operator	= $tampil["operator"];
										?>
										<tr>
											<td>
												<div class="isi" align="center">
													<?echo $i;?>
												</div>
											</td>
											<td>
												<div class="isi" align="center">
													<a href=""><?echo $nama_bandara;?></a>
												</div>
											</td>
											<td>
												<div class="isi" align="center">
													<?echo $alamat;?>
												</div>
											</td>
											<td>
												<div class="isi" align="center">
													<?echo $jenis;?>
												</div>
											</td>
											<td>
												<div class="isi" align="center">
													<?echo $operator;?>
												</div>
											</td>
										</tr>
										<?} if ($hasil=="") {?>
												<table>
													<tr>
														<td>
															<div class="text2">
																<? echo "Tidak Ada Data"; ?>
															</div>
														</td>
													</tr>
												</table>
										<?}?>
										</tbody>
									</table>

				</td>

		</tr>
	</table>

	</td>
	</tr>
</table>

</body>
</html>