Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: need help here

  1. #1
    Join Date
    Jun 2010
    Posts
    9

    Unanswered: 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

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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.

  3. #3
    Join Date
    Jun 2010
    Posts
    9
    Quote Originally Posted by Pat Phelan View Post
    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

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by buntalamus View Post
    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 ...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2010
    Posts
    9
    no output data....db connect succesfully....but no data display

  6. #6
    Join Date
    Jun 2010
    Posts
    9
    Quote Originally Posted by r937 View Post
    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

  7. #7
    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....

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by buntalamus View Post
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Jun 2010
    Posts
    9
    Quote Originally Posted by r937 View Post
    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....

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by buntalamus View Post
    already done...same result....
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Jun 2010
    Posts
    9
    Quote Originally Posted by r937 View Post
    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-alignleft;
    }
    .
    satu p {
        
    text-alignleft;
        
    font-size14px;
    }
    .
    satu #form2 {
        
    text-alignright;
    }
    .
    satu #form2 {
        
    text-alignleft;
    }
    DUA {
        
    text-aligncenter;
    }
    .
    DUA {
        
    text-aligncenter;
        
    font-weightbold;
        
    font-family"Lucida Sans Unicode""Lucida Grande"sans-serif;
        
    color#00F;
        
    font-size24px;
    }
    .
    satu #form1 p {
        
    text-aligncenter;
    }
    .
    satu #form1 p {
        
    font-size24px;
    }
    .
    satu #form3 {
        
    font-weightbold;
    }
    .
    satu #form4 p {
        
    font-weightbold;
    }
    .
    satu #form6 {
        
    font-weightbold;
    }
    .
    satu #form8 {
        
    font-weightbold;
    }
    .
    satu #form10 {
        
    font-weightbold;
    }
    .
    satu #form12 {
        
    text-aligncenter;
    }
    </
    style>
    </
    head>

    <
    body class="satu">
    <
    p>&nbsp;</p>
    <
    form action="" method="post" name="form1" class="DUA" id="form1">
      <
    p>SISTEM MAKLUMAT e-GAJI
      
    </p>
      <
    p>JPN KEDAH</p>
    </
    form>
    <
    p>&nbsp; </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>&nbsp;</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...

  12. #12
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by buntalamus View Post
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  13. #13
    Join Date
    Jun 2010
    Posts
    9
    Quote Originally Posted by r937 View Post
    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..

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by buntalamus View Post
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Jun 2010
    Posts
    9
    Quote Originally Posted by r937 View Post
    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..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •