wts> sapphire 5870 Vapor-X

akeemz — Sun, 17 Mar 2013 09:11:09 +0800

Item(s):sapphire 5870 Vapor-X

Package includes: box and gpu

Price:380

Warranty:3 day from me

Dealing method:cod or postage

Location of seller:sg petani

Contact method/details:
» Click to show Spoiler - click again to hide... «
zero 1 7 4 4 six six 44 2

Age of item:almost a year

---

Item(s) conditions:kicking

Picture:
» Click to show Spoiler - click again to hide... «
[attachmentid=3353177]

Reason for sale:switch to laptop

NEED HELP HERE..(MULTIPLE QUERIES SQL DATA)

akeemz — Wed, 09 Jun 2010 15:57:38 +0800

THIS IS MY SEARCH SCRIPT

CODE

<?php require_once('db_connect.php'); ?>
<?php
mysql_select_db($database);
$query_q_carikp = "SELECT
gaji.nama,
pusat_pembayar,
gred,
tangga_gaji,
tpg,
gaji.no_gaji,
kod_1052,butiran_1052,pusat_1052,jumlah_1052,
kod_1054,butiran_1054,pusat_1054,jumlah_1054,
kod_1055,butiran_1055,pusat_1055,jumlah_1055,
kod_1233,butiran_1233,pusat_1233,jumlah_1233,
kod_1251,butiran_1251,pusat_1251,jumlah_1251,
kod_1254,butiran_1254,pusat_1254,jumlah_1254,
kod_1260,butiran_1260,pusat_1260,jumlah_1260,
kod_1310,butiran_1310,pusat_1310,jumlah_1310,
kod_1328,butiran_1328,pusat_1328,jumlah_1328,
kod_1336,butiran_1336,pusat_1336,jumlah_1336,
kod_1351,butiran_1351,pusat_1351,jumlah_1351,
kod_1352,butiran_1352,pusat_1352,jumlah_1352,
kod_1362,butiran_1362,pusat_1362,jumlah_1362,
kod_1504,butiran_1504,pusat_1504,jumlah_1504,
kod_1505,butiran_1505,pusat_1505,jumlah_1505,
kod_1534,butiran_1534,pusat_1534,jumlah_1534,
tarikh_mula,
tarikh_akhir,
kod_potongan,
butiranpotong,
pusat_pembayaranptg,
no_rujukan,
jumlah_potong

FROM elaun1052
RIGHT OUTTER
JOIN elaun1054
ON elaun1054.nama = elaun1052.nama
RIGHT OUTTER
JOIN elaun1055
ON elaun1055.nama = elaun1054.nama
RIGHT OUTTER
JOIN elaun1233
ON elaun1233.nama = elaun1055.nama
RIGHT OUTTER
JOIN elaun1251
ON elaun1251.nama = elaun1233.nama
RIGHT OUTTER
JOIN elaun1254
ON elaun1254.nama = elaun1251.nama
RIGHT OUTTER
JOIN elaun1260
ON elaun1260.nama = elaun1254.nama
RIGHT OUTTER
JOIN elaun1310
ON elaun1310.nama = elaun1260.nama
RIGHT OUTTER
JOIN elaun1328
ON elaun1328.nama = elaun1310.nama
RIGHT OUTTER
JOIN elaun1336
ON elaun1336.nama = elaun1328.nama
RIGHT OUTTER
JOIN elaun1351
ON elaun1351.nama = elaun1336.nama
RIGHT OUTTER
JOIN elaun1352
ON elaun1352.nama = elaun1351.nama
RIGHT OUTTER
JOIN elaun1362
ON elaun1362.nama = elaun1352.nama
RIGHT OUTTER
JOIN elaun1504
ON elaun1504.nama = elaun1362.nama
RIGHT OUTTER
JOIN elaun1505
ON elaun1505.nama = elaun1504.nama
RIGHT OUTTER
JOIN elaun1534
ON elaun1534.nama = elaun1505.nama
RIGHT OUTTER
JOIN gaji
ON gaji.nama = elaun1534.nama
RIGHT OUTTER
JOIN potongan
ON potongan.nama = gaji.nama
WHERE gaji.no_gaji = 'no_gaji'";
$q_carikp = mysql_query($query_q_carikp) or die(mysql_error());
$row_q_carikp = mysql_fetch_assoc($q_carikp);
$totalRows_q_carikp = mysql_num_rows($q_carikp);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<form action="" method="post" name="form1" class="DUA" id="form1">
<p>SISTEM MAKLUMAT e-GAJI
</p>
<p>JPN KEDAH</p>
</form>
<form action="cuba.php" method="post" name="form1" target="_self" id="form13">
<p>.:CARIAN DATA:.</p>
<p>No Gaji :
<input name="no_gaji" type="text" id="no_gaji" />
<input type="submit" name="Submit" value="Cari" />
</p>
<p>*sila masukan no gaji</p>
</form>
<p>
</body>
</html>

<?php
mysql_free_result($q_carikp);
?>

THIS IS MY QUERIES

CODE

<?php require_once('db_connect.php'); ?>
<?php

$colname_q_ki_jumpa = "1";
if (isset($_POST['no_gaji'])) {
$colname_q_ki_jumpa = (get_magic_quotes_gpc()) ? $_POST['no_gaji'] : addslashes($_POST['no_gaji']);
}
mysql_select_db($database);
$query_q_ki_jumpa = sprintf("SELECT
gaji.nama,
pusat_pembayar,
gred,
tangga_gaji,
tpg,
gaji.no_gaji,
kod_1052,butiran_1052,pusat_1052,jumlah_1052,
kod_1054,butiran_1054,pusat_1054,jumlah_1054,
kod_1055,butiran_1055,pusat_1055,jumlah_1055,
kod_1233,butiran_1233,pusat_1233,jumlah_1233,
kod_1251,butiran_1251,pusat_1251,jumlah_1251,
kod_1254,butiran_1254,pusat_1254,jumlah_1254,
kod_1260,butiran_1260,pusat_1260,jumlah_1260,
kod_1310,butiran_1310,pusat_1310,jumlah_1310,
kod_1328,butiran_1328,pusat_1328,jumlah_1328,
kod_1336,butiran_1336,pusat_1336,jumlah_1336,
kod_1351,butiran_1351,pusat_1351,jumlah_1351,
kod_1352,butiran_1352,pusat_1352,jumlah_1352,
kod_1362,butiran_1362,pusat_1362,jumlah_1362,
kod_1504,butiran_1504,pusat_1504,jumlah_1504,
kod_1505,butiran_1505,pusat_1505,jumlah_1505,
kod_1534,butiran_1534,pusat_1534,jumlah_1534,
tarikh_mula,
tarikh_akhir,
kod_potongan,
butiranpotong,
pusat_pembayaranptg,
no_rujukan,
jumlah_potong

FROM elaun1052
RIGHT OUTTER
JOIN elaun1054
ON elaun1054.nama = elaun1052.nama
RIGHT OUTTER
JOIN elaun1055
ON elaun1055.nama = elaun1054.nama
RIGHT OUTTER
JOIN elaun1233
ON elaun1233.nama = elaun1055.nama
RIGHT OUTTER
JOIN elaun1251
ON elaun1251.nama = elaun1233.nama
RIGHT OUTTER
JOIN elaun1254
ON elaun1254.nama = elaun1251.nama
RIGHT OUTTER
JOIN elaun1260
ON elaun1260.nama = elaun1254.nama
RIGHT OUTTER
JOIN elaun1310
ON elaun1310.nama = elaun1260.nama
RIGHT OUTTER
JOIN elaun1328
ON elaun1328.nama = elaun1310.nama
RIGHT OUTTER
JOIN elaun1336
ON elaun1336.nama = elaun1328.nama
RIGHT OUTTER
JOIN elaun1351
ON elaun1351.nama = elaun1336.nama
RIGHT OUTTER
JOIN elaun1352
ON elaun1352.nama = elaun1351.nama
RIGHT OUTTER
JOIN elaun1362
ON elaun1362.nama = elaun1352.nama
RIGHT OUTTER
JOIN elaun1504
ON elaun1504.nama = elaun1362.nama
RIGHT OUTTER
JOIN elaun1505
ON elaun1505.nama = elaun1504.nama
RIGHT OUTTER
JOIN elaun1534
ON elaun1534.nama = elaun1505.nama
RIGHT OUTTER
JOIN gaji
ON gaji.nama = elaun1534.nama
RIGHT OUTTER
JOIN potongan
ON potongan.nama = gaji.nama
WHERE gaji.no_gaji = '%s'",$colname_q_ki_jumpa) or die(mysql_error());
$q_ki_jumpa = mysql_query($query_q_ki_jumpa) or die(mysql_error());
$row_q_ki_jumpa = mysql_fetch_assoc($q_ki_jumpa) or die(mysql_error());
$totalRows_q_ki_jumpa = mysql_num_rows($q_ki_jumpa)or die(mysql_error());

$colname_Recordset1 = "1";
if (isset($_GET['no_gaji'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['no_gaji'] : addslashes($_GET['no_gaji']);
}
mysql_select_db($database);
$query_Recordset1 = sprintf("SELECT
gaji.nama,
pusat_pembayar,
gred,
tangga_gaji,
tpg,
gaji.no_gaji,
kod_1052,butiran_1052,pusat_1052,jumlah_1052,
kod_1054,butiran_1054,pusat_1054,jumlah_1054,
kod_1055,butiran_1055,pusat_1055,jumlah_1055,
kod_1233,butiran_1233,pusat_1233,jumlah_1233,
kod_1251,butiran_1251,pusat_1251,jumlah_1251,
kod_1254,butiran_1254,pusat_1254,jumlah_1254,
kod_1260,butiran_1260,pusat_1260,jumlah_1260,
kod_1310,butiran_1310,pusat_1310,jumlah_1310,
kod_1328,butiran_1328,pusat_1328,jumlah_1328,
kod_1336,butiran_1336,pusat_1336,jumlah_1336,
kod_1351,butiran_1351,pusat_1351,jumlah_1351,
kod_1352,butiran_1352,pusat_1352,jumlah_1352,
kod_1362,butiran_1362,pusat_1362,jumlah_1362,
kod_1504,butiran_1504,pusat_1504,jumlah_1504,
kod_1505,butiran_1505,pusat_1505,jumlah_1505,
kod_1534,butiran_1534,pusat_1534,jumlah_1534,
tarikh_mula,
tarikh_akhir,
kod_potongan,
butiranpotong,
pusat_pembayaranptg,
no_rujukan,
jumlah_potong

FROM elaun1052
RIGHT OUTTER
JOIN elaun1054
ON elaun1054.nama = elaun1052.nama
RIGHT OUTTER
JOIN elaun1055
ON elaun1055.nama = elaun1054.nama
RIGHT OUTTER
JOIN elaun1233
ON elaun1233.nama = elaun1055.nama
RIGHT OUTTER
JOIN elaun1251
ON elaun1251.nama = elaun1233.nama
RIGHT OUTTER
JOIN elaun1254
ON elaun1254.nama = elaun1251.nama
RIGHT OUTTER
JOIN elaun1260
ON elaun1260.nama = elaun1254.nama
RIGHT OUTTER
JOIN elaun1310
ON elaun1310.nama = elaun1260.nama
RIGHT OUTTER
JOIN elaun1328
ON elaun1328.nama = elaun1310.nama
RIGHT OUTTER
JOIN elaun1336
ON elaun1336.nama = elaun1328.nama
RIGHT OUTTER
JOIN elaun1351
ON elaun1351.nama = elaun1336.nama
RIGHT OUTTER
JOIN elaun1352
ON elaun1352.nama = elaun1351.nama
RIGHT OUTTER
JOIN elaun1362
ON elaun1362.nama = elaun1352.nama
RIGHT OUTTER
JOIN elaun1504
ON elaun1504.nama = elaun1362.nama
RIGHT OUTTER
JOIN elaun1505
ON elaun1505.nama = elaun1504.nama
RIGHT OUTTER
JOIN elaun1534
ON elaun1534.nama = elaun1505.nama
RIGHT OUTTER
JOIN gaji
ON gaji.nama = elaun1534.nama
RIGHT OUTTER
JOIN potongan
ON potongan.nama = gaji.nama
WHERE gaji.no_gaji = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">No Gaji:</td>
<td><?php echo $row_q_ki_jumpa['no_gaji']; ?></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Nama:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['nama']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">No Kad Pengenalan:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kad_pengenalan']; ?>" size="32"></td>
</tr>
</table>
<p> </p>
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="telefon" value="<?php echo $row_q_ki_jumpa['pusat_pembayar']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Gred:</td>
<td><input type="text" name="kod_potongan" value="<?php echo $row_q_ki_jumpa['gred']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Tangga Gaji:</td>
<td><input type="text" name="kod_elaun" value="<?php echo $row_q_ki_jumpa['tangga_gaji']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">TPG:</td>
<td><input type="text" name="telefon" value="<?php echo $row_q_ki_jumpa['tpg']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Gaji:</td>
<td><input type="text" name="telefon" value="<?php echo $row_q_ki_jumpa['gaji']; ?>" size="32"></td>
</tr>
</table>
<p> </p>
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Kod Elaun 1:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1052']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 9:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1328']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1052']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1328']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1052']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1328']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1052']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1328']; ?>" size="32"></td>

<tr valign="baseline">
<td nowrap align="right">Kod Elaun 2:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1054']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 10:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1336']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1054']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1336']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1054']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1336']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1054']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1336']; ?>" size="32"></td>

<tr valign="baseline">
<td nowrap align="right">Kod Elaun 3:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1055']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 11:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1351']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1055']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1351']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1055']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1351']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1055']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1351']; ?>" size="32"></td>

<tr valign="baseline">
<td nowrap align="right">Kod Elaun 4:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1233']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 12:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1352']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1233']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1352']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1233']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1352']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1233']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1352']; ?>" size="32"></td>

<tr valign="baseline">
<td nowrap align="right">Kod Elaun 5:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1251']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 13:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1362']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1251']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1362']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1251']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1362']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1251']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1362']; ?>" size="32"></td>

<tr valign="baseline">
<td nowrap align="right">Kod Elaun 6:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1254']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 14:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1504']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1254']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1504']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1254']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1504']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1254']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1504']; ?>" size="32"></td>

<tr valign="baseline">
<td nowrap align="right">Kod Elaun 7:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1260']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 15:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1505']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1260']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1505']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1260']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1505']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1260']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1505']; ?>" size="32"></td>

<tr valign="baseline">
<td nowrap align="right">Kod Elaun 8:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1310']; ?>" size="32"></td> <td nowrap align="right">Kod Elaun 16:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_1534']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1310']; ?>" size="32"></td><td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiran_1534']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1310']; ?>" size="32"></td><td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_1534']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1310']; ?>" size="32"></td><td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_1534']; ?>" size="32"></td>
</tr>
</table>
<p> </p>
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Tarikh Mula:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['tarikh_mula']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Tarikh Akhir:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['tarikh_akhir']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Kod Potongan:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['kod_potongan']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Butiran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['butiranpotong']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Pusat Pembayaran:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['pusat_pembayaranptg']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">No Rujukan:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['no_rujukan']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Jumlah:</td>
<td><input type="text" name="nama" value="<?php echo $row_q_ki_jumpa['jumlah_potong']; ?>" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Update record"></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1">
<input type="hidden" name="nokp" value="<?php echo $row_q_ki_jumpa['no_gaji']; ?>">
</p>
</p>
</p>
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($q_ki_jumpa);

mysql_free_result($Recordset1);
?>

MY RPOBLEM IS....WHEN I PUT NO GAJI INTHE SEARCH COLUMN, THE PAGE TOOK A VERY LONG TIME TO LOADING....ALMOST 3 HOUR, STILL LOADING..NOTHING HAPPEN....

I'VE TRY TO CHANGE TO INNER JOIN...BUT SAME RESULT...

CAN SOMEBODY HELP ME?

Lowyat.NET: Latest topics by akeemz

wts> sapphire 5870 Vapor-X

NEED HELP HERE..(MULTIPLE QUERIES SQL DATA)