| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|
06-05-10, 09:39
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
|
need help here
|
|
hello
sorry if i park in the wrong place..
here is my code
PHP Code:
<?php
$username = "dzokieco_admin";
$password = "password";
$hostname = "localhost";
$database = "dzokieco_gaji";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Welcome Marzuki Bin Ahmad<br>";
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM elaun1052,elaun1054,elaun1055,elaun1233,elaun1251, elaun1254,elaun1260,elaun1310,elaun1328,elaun1336, elaun1351,elaun1352,elaun1362,elaun1504,elaun1505, elaun1534,gajipaycentre,potongan4118,potongan4141, potongan4142,potongan4156,potongan4182,potongan418 3,potongan4184,potongan4189,senarai WHERE elaun1052.no_gaji=elaun1054.no_gaji=elaun1055.no_g aji=elaun1233.no_gaji=elaun1251.no_gaji=elaun1254. no_gaji=elaun1260.no_gaji=elaun1310.no_gaji=elaun1 328.no_gaji=elaun1336.no_gaji=elaun1351.no_gaji=el aun1352.no_gaji=elaun1362.no_gaji=elaun1504.no_gaj i=elaun1505.no_gaji=elaun1534.no_gaji=gajipaycentr e.no_gaji=potongan4118.no_gaji=potongan4141.no_gaj i=potongan4142.no_gaji=potongan4156.no_gaji=potong an4182.no_gaji=potongan4183.no_gaji=potongan4184.n o_gaji=potongan4189.no_gaji";
$result=mysql_query($query) or die(mysql_error());
while ($r = mysql_fetch_array($result ));
//the format is $variable = $r["nameofmysqlcolumn"];
//modify these to match your mysql table columns
$nama=$r['nama'];
$no_gaji=$r['no_gaji'];
$kad_pengenalan=$r['kad_pengenalan'];
$kod_sekolah=$r['kod_sekolah'];
$PPD=$r['PPD'];
$nama_sekolah=$r['nama_sekolah'];
$jenis_sekolah=$r['jenis_sekolah'];
$email=$r['email'];
$alamat_surat=$r['alamat_surat'];
$bandar_surat=$r['bandar_surat'];
$poskod_surat=$r['poskod_surat'];
$gred_sekolah=$r['gred_sekolah'];
$no_telefon=$r['no_telefon'];
$no_fax=$r['no_fax'];
$pusat_pembayar=$r['pusat_pembayar'];
$no_gaji=$r['no_gaji'];
$gred=$r['gred'];
$tangga_gaji=$r['tangga_gaji'];
$tpg=$r['tpg'];
$gaji=$r['gaji'];
$kod_elaun=$r['kod_elaun'];
$butiran=$r['butiran'];
$pusat_pembayaran=$r['pusat_pembayaran'];
$jumlah=$r['jumlah'];
$tarikh_mula=$r['tarikh_mula'];
$tarikh_akhir=$r['tarikh_akhir'];
$kod_potongan=$r['kod_potongan'];
$no_rujukan=$r['no_rujukan'];
$butiran=$r['butiran'];
$jumlah=$r['jumlah'];
$pusat_pembayaran=$r['pusat_pembayaran'];
echo "<b><center>.:Hasil Carian Anda:.</center></b><br><br>";
{
echo "$nama<br> $no_gaji<br> $kad_pengenalan<br> $kod_sekolah<br> $PPD<br> $nama_sekolah<br> $jenis_sekolah<br> $email<br> $alamat_surat<br> $bandar_surat<br> $poskod_surat<br> $gred_sekolah<br> $no_telefon<br> $no_fax<br> $pusat_pembayar<br> $no_gaji<br> $gred<br> $tangga_gaji<br> $tpg<br> $gaji<br> $kod_elaun<br> $butiran<br> $pusat_pembayaran<br> $jumlah<br> $tarikh_mula<br> $tarikh_akhir<br> $kod_potongan<br> $no_rujukan<br> $butiran<br> $jumlah<br> $pusat_pembayaran<br>";
echo "<\br>";
}
?>
my problem is, when i clik at search button using no_gaji as a key, the page loading and no result display...its almost 2 hour i wait...but still loading....can any1 here help me?im newbies here...
thanks
|
|
06-05-10, 10:15
|
|
Resident Curmudgeon
|
|
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,606
|
|
I'm nearly certain that your "SELECT *" is your problem. I think that you log in successfully, then spend forever trying to return a result set that is too large for your system to handle. At least to test my theory, simplify your result set down to one column from one table with only one row in the result and see what happens.
-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
|
|
06-05-10, 10:23
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
|
|
Quote:
Originally Posted by Pat Phelan
I'm nearly certain that your "SELECT *" is your problem. I think that you log in successfully, then spend forever trying to return a result set that is too large for your system to handle. At least to test my theory, simplify your result set down to one column from one table with only one row in the result and see what happens.
-PatP
|
i'll try...thanks in advance
|
|
06-05-10, 10:27
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
|
|
Quote:
Originally Posted by buntalamus
the page loading and no result display...its almost 2 hour i wait...but still loading....
|
here's your problem --
Code:
SELECT *
FROM elaun1052
, elaun1054
, elaun1055
, elaun1233
, elaun1251
, elaun1254
, elaun1260
, elaun1310
, elaun1328
, elaun1336
, elaun1351
, elaun1352
, elaun1362
, elaun1504
, elaun1505
, elaun1534
, gajipaycentre
, potongan4118
, potongan4141
, potongan4142
, potongan4156
, potongan4182
, potongan4183
, potongan4184
, potongan4189
, senarai
WHERE elaun1052.no_gaji
= elaun1054.no_gaji
= elaun1055.no_gaji
= elaun1233.no_gaji
= elaun1251.no_gaji
= elaun1254.no_gaji
= elaun1260.no_gaji
= elaun1310.no_gaji
= elaun1328.no_gaji
= elaun1336.no_gaji
= elaun1351.no_gaji
= elaun1352.no_gaji
= elaun1362.no_gaji
= elaun1504.no_gaji
= elaun1505.no_gaji
= elaun1534.no_gaji
= gajipaycentre.no_gaji
= potongan4118.no_gaji
= potongan4141.no_gaji
= potongan4142.no_gaji
= potongan4156.no_gaji
= potongan4182.no_gaji
= potongan4183.no_gaji
= potongan4184.no_gaji
= potongan4189.no_gaji
the WHERE clause is invalid, so you are getting a cross join of all possible combinations of rows from all those tables
if each table has only 5 rows, this cross join produces 5 * 5 * 5 * 5 * ... * 5 = 1,490,116,119,384,765,625 rows
(if you returned 1000 rows per second, this would take 47 million years)
you need to join the tables properly one at a time --
Code:
SELECT something
, anything
, just_not_the_dreaded_evil_select_star
FROM elaun1052
INNER
JOIN elaun1054
ON elaun1054.no_gaji = elaun1052.no_gaji
INNER
JOIN elaun1055
ON elaun1055.no_gaji = elaun1054.no_gaji
INNER
JOIN elaun1233
ON elaun1233.no_gaji = elaun1055.no_gaji
INNER
JOIN ...
|
|
06-05-10, 10:29
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
no output data....db connect succesfully....but no data display
|
|
06-05-10, 10:31
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
Quote:
Originally Posted by r937
here's your problem --
Code:
SELECT *
FROM elaun1052
, elaun1054
, elaun1055
, elaun1233
, elaun1251
, elaun1254
, elaun1260
, elaun1310
, elaun1328
, elaun1336
, elaun1351
, elaun1352
, elaun1362
, elaun1504
, elaun1505
, elaun1534
, gajipaycentre
, potongan4118
, potongan4141
, potongan4142
, potongan4156
, potongan4182
, potongan4183
, potongan4184
, potongan4189
, senarai
WHERE elaun1052.no_gaji
= elaun1054.no_gaji
= elaun1055.no_gaji
= elaun1233.no_gaji
= elaun1251.no_gaji
= elaun1254.no_gaji
= elaun1260.no_gaji
= elaun1310.no_gaji
= elaun1328.no_gaji
= elaun1336.no_gaji
= elaun1351.no_gaji
= elaun1352.no_gaji
= elaun1362.no_gaji
= elaun1504.no_gaji
= elaun1505.no_gaji
= elaun1534.no_gaji
= gajipaycentre.no_gaji
= potongan4118.no_gaji
= potongan4141.no_gaji
= potongan4142.no_gaji
= potongan4156.no_gaji
= potongan4182.no_gaji
= potongan4183.no_gaji
= potongan4184.no_gaji
= potongan4189.no_gaji
the WHERE clause is invalid, so you are getting a cross join of all possible combinations of rows from all those tables
if each table has only 5 rows, this cross join produces 5 * 5 * 5 * 5 * ... * 5 = 1,490,116,119,384,765,625 rows
(if you returned 1000 rows per second, this would take 47 million years)
you need to join the tables properly one at a time --
Code:
SELECT something
, anything
, just_not_the_dreaded_evil_select_star
FROM elaun1052
INNER
JOIN elaun1054
ON elaun1054.no_gaji = elaun1052.no_gaji
INNER
JOIN elaun1055
ON elaun1055.no_gaji = elaun1054.no_gaji
INNER
JOIN elaun1233
ON elaun1233.no_gaji = elaun1055.no_gaji
INNER
JOIN ...
|
ok...i'll try...thanks 
|
|
06-05-10, 10:54
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
PHP Code:
<?php
$username = "dzokieco_admin";
$password = "password";
$hostname = "localhost";
$database = "dzokieco_gaji";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Welcome Marzuki Bin Ahmad<br>";
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM elaun1052
INNER
JOIN elaun1054
ON elaun1054.no_gaji = elaun1052.no_gaji
INNER
JOIN elaun1055
ON elaun1055.no_gaji = elaun1054.no_gaji
INNER
JOIN elaun1233
ON elaun1233.no_gaji = elaun1055.no_gaji
INNER
JOIN elaun1251
ON elaun1251.no_gaji = elaun1233.no_gaji
INNER
JOIN elaun1254
ON elaun1254.no_gaji = elaun1251.no_gaji
INNER
JOIN elaun1260
ON elaun1260.no_gaji = elaun1254.no_gaji
INNER
JOIN elaun1310
ON elaun1310.no_gaji = elaun1260.no_gaji
INNER
JOIN elaun1328
ON elaun1328.no_gaji = elaun1310.no_gaji
INNER
JOIN elaun1336
ON elaun1336.no_gaji = elaun1328.no_gaji
INNER
JOIN elaun1351
ON elaun1351.no_gaji = elaun1336.no_gaji
INNER
JOIN elaun1352
ON elaun1352.no_gaji = elaun1351.no_gaji
INNER
JOIN elaun1362
ON elaun1362.no_gaji = elaun1352.no_gaji
INNER
JOIN elaun1504
ON elaun1504.no_gaji = elaun1362.no_gaji
INNER
JOIN elaun1505
ON elaun1505.no_gaji = elaun1504.no_gaji
INNER
JOIN elaun1534
ON elaun1534.no_gaji = elaun1505.no_gaji
INNER
JOIN gajipaycentre
ON gajipaycentre.no_gaji = elaun1534.no_gaji
INNER
JOIN potongan4118
ON potongan4118.no_gaji = gajipaycentre.no_gaji
INNER
JOIN potongan4141
ON potongan4141.no_gaji = potongan4118.no_gaji
INNER
JOIN potongan4142
ON potongan4142.no_gaji = potongan4141.no_gaji
INNER
JOIN potongan4156
ON potongan4156.no_gaji = potongan4142.no_gaji
INNER
JOIN potongan4182
ON potongan4182.no_gaji = potongan4156.no_gaji
INNER
JOIN potongan4183
ON potongan4183.no_gaji = potongan4182.no_gaji
INNER
JOIN potongan4184
ON potongan4184.no_gaji = potongan4183.no_gaji
INNER
JOIN potongan4189
ON potongan4189.no_gaji = potongan4184.no_gaji";
$result=mysql_query($query);
mysql_close();
echo "<b><center>.:Hasil Carian Anda:.</center></b><br><br>";
$i=0;
while ($i < $num) {
$nama=mysql_result($result,$i,"Nama");
$no_gaji=mysql_result($result,$i,"No Gaji");
$kad_pengenalan=mysql_result($result,$i,"No Kad Pengenalan");
$kod_sekolah=mysql_result($result,$i,"Kod Sekolah");
$PPD=mysql_result($result,$i,"PPD");
$nama_sekolah=mysql_result($result,$i,"Nama Sekolah");
$jenis_sekolah=mysql_result($result,$i,"Jenis Sekolah");
$email=mysql_result($result,$i,"Email Sekolah");
$alamat_surat=mysql_result($result,$i,"Alamat Sekolah");
$bandar_surat=mysql_result($result,$i,"Bandar");
$poskod_surat=mysql_result($result,$i,"Poskod");
$gred_sekolah=mysql_result($result,$i,"Gred Sekolah");
$no_telefon=mysql_result($result,$i,"No Telefon");
$no_fax=mysql_result($result,$i,"No Fax");
$pusat_pembayar=mysql_result($result,$i,"Pusat Pembayar");
$no_gaji=mysql_result($result,$i,"No Gaji");
$gred=mysql_result($result,$i,"Gred Gaji");
$tangga_gaji=mysql_result($result,$i,"Tangga Gaji");
$tpg=mysql_result($result,$i,"TPG");
$gaji=mysql_result($result,$i,"Gaji");
$kod_elaun=mysql_result($result,$i,"Kod Elaun");
$butiran=mysql_result($result,$i,"Butiran");
$pusat_pembayaran=mysql_result($result,$i,"Pusat Pembayaran");
$jumlah=mysql_result($result,$i,"Jumlah");
$tarikh_mula=mysql_result($result,$i,"Tarikh Mula");
$tarikh_akhir=mysql_result($result,$i,"Tarikh_Akhir");
$kod_potongan=mysql_result($result,$i,"Kod Potongan");
$no_rujukan=mysql_result($result,$i,"No Rujukan");
$butiran=mysql_result($result,$i,"Butiran");
$jumlah=mysql_result($result,$i,"Jumlah");
$pusat_pembayaran=mysql_result($result,$i,"Pusat Pembayaran");
echo "$nama<br> $no_gaji<br> $kad_pengenalan<br> $kod_sekolah<br> $PPD<br> $nama_sekolah<br> $jenis_sekolah<br> $email<br> $alamat_surat<br> $bandar_surat<br> $poskod_surat<br> $gred_sekolah<br> $no_telefon<br> $no_fax<br> $pusat_pembayar<br> $no_gaji<br> $gred<br> $tangga_gaji<br> $tpg<br> $gaji<br> $kod_elaun<br> $butiran<br> $pusat_pembayaran<br> $jumlah<br> $tarikh_mula<br> $tarikh_akhir<br> $kod_potongan<br> $no_rujukan<br> $butiran<br> $jumlah<br> $pusat_pembayaran<br>";
$i++;
}
?>
my new coding be like this....the problem is...there is no result...
the only thing that appear is
"welcome Marzuki bin Ahmad"
".:Hasil Carian Anda:."
advice please.... 
|
|
06-05-10, 11:05
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
|
|
Quote:
Originally Posted by buntalamus
the problem is...there is no result...
|
must be a problem with your data
start with only 2 tables in the query, and see if you get any results
add a third table, see if you get any results
add a fourth table, see if you get any results
somewhere along the line, the query will stop producing results -- that's when you will know you've found the data problem
|
|
06-05-10, 11:15
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
Quote:
Originally Posted by r937
must be a problem with your data
start with only 2 tables in the query, and see if you get any results
add a third table, see if you get any results
add a fourth table, see if you get any results
somewhere along the line, the query will stop producing results -- that's when you will know you've found the data problem
|
already done...same result.... 
|
|
06-05-10, 11:28
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
|
|
Quote:
Originally Posted by buntalamus
|
seriously??? you mean you get 0 rows from this query?
Code:
SELECT *
FROM elaun1052
INNER
JOIN elaun1054
ON elaun1054.no_gaji = elaun1052.no_gaji
really? 0 rows?
if that's true, then you have a really bad data problem
|
|
06-05-10, 11:40
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
Quote:
Originally Posted by r937
seriously??? you mean you get 0 rows from this query?
Code:
SELECT *
FROM elaun1052
INNER
JOIN elaun1054
ON elaun1054.no_gaji = elaun1052.no_gaji
really? 0 rows?
if that's true, then you have a really bad data problem |
ok....like this...
i have a form...from this form....if i put 'no_gaji' and click 'cari'...i want the database to display all the data regarding the 'no_gaji'
below is the code...
PHP Code:
<!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>
<style type="text/css">
.satu {
text-align: left;
}
.satu p {
text-align: left;
font-size: 14px;
}
.satu #form2 {
text-align: right;
}
.satu #form2 {
text-align: left;
}
DUA {
text-align: center;
}
.DUA {
text-align: center;
font-weight: bold;
font-family: "Lucida Sans Unicode", "Lucida Grande", sans-serif;
color: #00F;
font-size: 24px;
}
.satu #form1 p {
text-align: center;
}
.satu #form1 p {
font-size: 24px;
}
.satu #form3 {
font-weight: bold;
}
.satu #form4 p {
font-weight: bold;
}
.satu #form6 {
font-weight: bold;
}
.satu #form8 {
font-weight: bold;
}
.satu #form10 {
font-weight: bold;
}
.satu #form12 {
text-align: center;
}
</style>
</head>
<body class="satu">
<p> </p>
<form action="" method="post" name="form1" class="DUA" id="form1">
<p>SISTEM MAKLUMAT e-GAJI
</p>
<p>JPN KEDAH</p>
</form>
<p> </p>
<form id="form13" name="form13" method="post" action="insert.php">
<p>
<label for="search"></label>
<select name="search" id="search">
<option>No Gaji</option>
<option>No Kad Pengenalan</option>
</select>
<label for="textfield"></label>
<input type="text" name="textfield" id="textfield" />
<input type="submit" name="Cari" id="Cari" value="Cari" />
</p>
</form>
<form id="form3" name="form3" method="post" action="">
1.0 MAKLUMAT PERIBADI
</form>
<form id="form2" name="form2" method="get" action=" insert2.php">
<p>
<label for="nama">Nama : </label>
<input name="nama" type="varchar" id="nama" size="90" />
</p>
<p>
No Gaji :
<label for="no_gaji"></label>
<input name="no_gaji" type="varchar" id="no_gaji" size="30" />
No Kad Pengenalan :
<label for="kad_pengenalan"></label>
<input name="kad_pengenalan" type="varchar" id="kad_pengenalan" size="34" />
</p>
</form>
<form id="form4" name="form4" method="post" action="">
<p>2.0 MAKLUMAT SEKOLAH
</p>
</form>
<form id="form5" name="form5" method="get" action=" insert2.php">
<p>Kod Sekolah :
<label for="kod_sekolah"></label>
<input type="varchar" name="kod_sekolah" id="kod_sekolah" />
PPD :
<label for="PPD"></label>
<input name="PPD" type="varchar" id="PPD" size="52" />
</p>
<p>Nama Sekolah :
<label for="nama_sekolah"></label>
<input name="nama_sekolah" type="varchar" id="nama_sekolah" size="82" />
</p>
<p>Jenis Sekolah :
<label for="jenis_sekolah"></label>
<input type="varchar" name="jenis_sekolah" id="jenis_sekolah" />
Email Sekolah :
<label for="email"></label>
<input name="email" type="varchar" id="email" size="42" />
</p>
<p>Alamat Sekolah :
<label for="alamat_surat"></label>
<input name="alamat_surat" type="varchar" id="alamat_surat" size="81" />
</p>
<p>Bandar :
<label for="bandar_surat"></label>
<input type="varchar" name="bandar_surat" id="bandar_surat" />
Poskod :
<input type="varchar" name="poskod_surat" id="poskod_surat" />
Gred Sekolah :
<label for="gred_sekolah"></label>
<input name="gred_sekolah" type="varchar" id="gred_sekolah" size="15" />
</p>
<p>No Telefon :
<label for="no_telefon"></label>
<input name="no_telefon" type="varchar" id="no_telefon" size="36" />
No Fax :
<label for="no_fax"></label>
<input name="no_fax" type="varchar" id="no_fax" size="40" />
</p>
</form>
<form id="form6" name="form6" method="post" action="">
3.0 MAKLUMAT GAJI
</form>
<form id="form7" name="form7" method="get" action=" insert2.php">
<p>Pusat Pembayar :
<label for="pusat_pembayar"></label>
<input type="varchar" name="pusat_pembayar" id="pusat_pembayar" />
No Gaji :
<label for="no_gaji"></label>
<input type="varchar" name="no_gaji" id="no_gaji" />
</p>
<p>Gred Gaji :
<label for="gred"></label>
<input type="varchar" name="gred" id="gred" />
Tangga Gaji :
<label for="tangga_gaji"></label>
<input type="varchar" name="tangga_gaji" id="tangga_gaji" />
</p>
<p>TPG :
<label for="tpg"></label>
<input type="varchar" name="tpg" id="tpg" />
Gaji :
<label for="gaji"></label>
<input type="varchar" name="gaji" id="gaji" />
</p>
<p> </p>
</form>
<form id="form8" name="form8" method="post" action="">
4.0 MAKLUMAT ELAUN
</form>
<form id="form9" name="form9" method="get" action=" insert2.php">
<p>Kod Elaun :
<label for="kod_elaun"></label>
<textarea name="kod_elaun" cols="30" id="kod_elaun"></textarea>
Butiran :
<label for="butiran"></label>
<textarea name="butiran" cols="35" id="butiran"></textarea>
</p>
<p>Pusat Pembayaran :
<label for="pusat_pembayaran"></label>
<input type="varchar" name="pusat_pembayaran" id="pusat_pembayaran" />
Jumlah :
<label for="jumlah"></label>
<input type="varchar" name="jumlah" id="jumlah" />
</p>
</form>
<form id="form10" name="form10" method="post" action="">
5.0 MAKLUMAT PEMOTONGAN
</form>
<form id="form11" name="form11" method="get" action=" insert2.php">
<p>Tarikh Mula :
<label for="tarikh_mula"></label>
<input type="varchar" name="tarikh_mula" id="tarikh_mula" />
Tarikh Akhir :
<label for="tarikh_akhir"></label>
<input type="varchar" name="tarikh_akhir" id="tarikh_akhir" />
</p>
<p>Kod Potongan :
<label for="kod_potongan"></label>
<input type="varchar" name="kod_potongan" id="kod_potongan" />
No Rujukan :
<label for="no_rujukan"></label>
<input type="varchar" name="no_rujukan" id="no_rujukan" />
</p>
<p>Butiran :
<label for="butiran"></label>
<textarea name="butiran" cols="40" id="butiran"></textarea>
Jumlah :
<label for="jumlah"></label>
<input type="varchar" name="jumlah" id="jumlah" />
</p>
<p>Pusat Pembayar :
<label for="pusat_pembayar"></label>
<input type="varchar" name="pusat_pembayar" id="pusat_pembayar" />
</p>
</form>
<form id="form12" name="form12" method="get" action=" insert2.php">
<input type="submit" name="Hantar" id="Hantar" value="Submit" />
</form>
<p>
</body>
</html>
all my table have the no_gaji.. so here i want to display all the data by inserting the no_gaji..
but till now...the data wont display...
|
|
06-05-10, 11:45
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
|
|
Quote:
Originally Posted by buntalamus
below is the code...
|
this does not help at all
where are you testing your queries? mysql workbench? sqlyog? heidisql? navicat? phpmyadmin? mysql command line?
forget php for a while, and concentrate on getting your query to work properly first
|
|
06-05-10, 11:55
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
Quote:
Originally Posted by r937
this does not help at all
where are you testing your queries? mysql workbench? sqlyog? heidisql? navicat? phpmyadmin? mysql command line?
forget php for a while, and concentrate on getting your query to work properly first
|
phpmyadmin..
|
|
06-05-10, 12:03
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
|
|
Quote:
Originally Posted by buntalamus
phpmyadmin.. |
awesome, now we're getting somewhere 
so how many rows did you get for this query in phpmyadmin --
Code:
SELECT *
FROM elaun1052
INNER
JOIN elaun1054
ON elaun1054.no_gaji = elaun1052.no_gaji
|
|
06-05-10, 12:16
|
|
Registered User
|
|
Join Date: Jun 2010
Posts: 9
|
|
Quote:
Originally Posted by r937
awesome, now we're getting somewhere
so how many rows did you get for this query in phpmyadmin --
Code:
SELECT *
FROM elaun1052
INNER
JOIN elaun1054
ON elaun1054.no_gaji = elaun1052.no_gaji
|
nothing....
just the welcome marzuki ahmad and the hasil carian anda..
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
need help here
