coba ini

<?php
# UNTUK PAGING (PEMBAGIAN HALAMAN)
$lim = 50;
$hal = isset($_GET['hal']) ? $_GET['hal'] : 0;
//$pageSql = "SELECT * FROM Reservasi WHERE no_Reservasi NOT IN (SELECT nama FROM reservasi)";
//$pageQry = mysql_query($pageSql, $koneksidb) or die ("error paging: ".mysql_error());

if($_GET) {
# Jika tombol Cari/Search diklik, maka pencarian dilakukan
if(isset($_POST['btnSearch'])){
if($_POST) {
$mySql = "SELECT Reservasi.*, pasien.nama, dokter.nm_dokter
FROM reservasi, pasien, dokter
WHERE reservasi.kd_pasien=pasien.kd_pasien AND reservasi.kd_dokter=dokter.kd_dokter
AND pasien.nama LIKE '%".$_POST['txtCari']."%'
AND reservasi.no_reservasi NOT IN (SELECT no_reservasi FROM Reservasi)
ORDER BY (SUBSTR(reservasi.no_reservasi,6) + 0) ASC LIMIT $hal, $lim";
}
}
else {
$mySql = "SELECT reservasi.*, pasien.nama, dokter.nm_dokter
FROM reservasi, pasien, dokter
WHERE reservasi.kd_pasien=pasien.kd_pasien AND reservasi.kd_dokter=dokter.kd_dokter
AND reservasi.no_reservasi NOT IN (SELECT no_reservasi FROM Reservasi)
ORDER BY (SUBSTR(reservasi.no_reservasi,6) + 0) ASC LIMIT $hal, $lim";
}
} // End if($_GET) {



$myQry = mysql_query($mySql, $koneksidb) or die ("Query reservasi salah : ".mysql_error());
$jml = mysql_num_rows($myQry);
$max = ceil($jml/$lim);
?>
<table width="1110" height="192" border="0" class="table-border">
<tr>
<td colspan="2" align="right"><img src="images/data_reservasi.png" width="300" height="60" /></td>
</tr>
<tr> </tr>
<tr>
<td width="394"><form action="?page=Show-Reservasi" method="post" name="form1" target="_self" id="form1">
<b>Cari Nama Pasien :
<input name="txtCari" type="text" value="<?php echo isset($_POST['txtCari']) ? $_POST['txtCari'] : '';?>" size="20" maxlength="100" />
<input name="btnSearch" type="submit" value="Cari" />
</b>
</form></td>
<td width="511"><div align="center"><b>Jumlah Data :</b> <?php echo $jml; ?> </div></td>
<td width="10"></td>
<td width="102" align="right"><a href="?page=Add-Reservasi" target="_self"><img src="images/btn_add_data2.png" height="25" border="0" /></a> </td>
<td width="10">&nbsp;</td>
</tr>
<tr>
<td colspan="2"><table class="table-list" width="104%" border="0" cellspacing="1" cellpadding="2">
<tr>
<th width="29" align="center" bgcolor="‪#‎CCCCCC‬"><b>No</b></th>
<th width="77" align="center" bgcolor="#CCCCCC">No Reservasi </th>
<th width="77" align="center" bgcolor="#CCCCCC">Daftar </th>
<th width="87" align="center" bgcolor="#CCCCCC">Operasi </th>
<th width="133" bgcolor="#CCCCCC"><b>Nama Pasien </b></th>
<th width="121" bgcolor="#CCCCCC">Dignosa </th>
<th width="147" bgcolor="#CCCCCC">Nama Dokter </th>
<th width="104" align="center" bgcolor="#CCCCCC"><div align="center">Keterangan</div></th>
<td colspan="3" align="center" bgcolor="#CCCCCC"><b>Tools</b><b></b></td>
</tr>
<?php
# Tampilkan data pasien, SQL-nya ada di halaman atas

$nomor = 0;
while ($myData = mysql_fetch_array($myQry)) {
$nomor++;
$Kode = $myData['no_reservasi'];
// gradasi warna
if($nomor%2==1) { $warna=""; } else {$warna="‪#‎F5F5F5‬";}
?>
<tr bgcolor="<?php echo $warna; ?>">
<td align="center"><b><?php echo $nomor; ?></b></td>
<td align="center"><b><?php echo $myData['no_Reservasi']; ?></b></td>
<td align="center"><?php echo IndonesiaTgl($myData['tgl_daftar']); ?></td>
<td align="center"><?php echo IndonesiaTgl($myData['tgl_periksa']); ?></td>
<td><?php echo $mydata['nama']; ?></td>
<td><b><?php echo $myData['diagnosa']; ?></b></td>
<td><?php echo $myData['kd_dokter']; ?></td>
<td align="center"><div align="center"><?php echo $myData['keluhan']; ?></div></td>
<td width="45" align="center"><a href="?page=Add-Periksa&amp;Kode=<?php echo $Kode; ?>" target="_self" alt="Periksa Dokter">Periksa</a></td>
<td width="41" align="center"><a href="?page=Edit-Pendaftaran&amp;Kode=<?php echo $Kode; ?>" target="_self" alt="Edit Data">Edit</a></td>
<td width="51" align="center"><a href="?page=Delete-Pendaftaran&amp;Kode=<?php echo $Kode; ?>" target="_self" alt="Delete Data" onclick="return confirm('Yakin akan menghapus data ini ?')">Delete</a></td>
</tr>
<?php } ?>
</table></td>
</tr>
<tr>
<td align="right"><div align="left"><b>Halaman ke :</b>
<?php
for ($h = 1; $h <= $max; $h++) {
$list[$h] = $lim * $h - $lim;
echo " <a href='?page=Show-Reservasi&hal=$list[$h]'>$h</a> ";
}
?>
</div></td>
</tr>
</table>