Wrox Programmer Forums
|
PHP How-To Post your "How do I do this with PHP?" questions here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 15th, 2004, 12:07 PM
Authorized User
 
Join Date: Jan 2004
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default INNER JOIN??

this is my snippet of code:
Code:
 function query($query,$line, $file)
{
    $result = mysql_query($query);
      if (empty($result) && ini_get('display_errors') == 1)
        {
            echo mysql_error().": ";
            echo mysql_errno()."<br />\n";
            echo $query."<br />\n";
            echo "@ $line in $file\n";
        }
    return $result;
    }
?>

<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</head>
<body>
<form name="myform">

<?

   $status= "Diproses";
   $jenis="BM";
    $SQL = query("UPDATE aduankerosakan SET status = '$status' WHERE idAduan = '{$_POST["id"]}' ", __LINE__, __FILE__); 
    $maklumat = query("SELECT * FROM aduankerosakan INNER JOIN tpartminor ON aduankerosakan.idMajor = tpartminor.idMajor WHERE aduankerosakan.idAduan = '{$_POST["id"]}'", __LINE__, __FILE__);
i use the query function recommended by quasedilla5,its really helping...
but i think something wrong with my SQL statement above...
the UPDATE process seems failed,and all information taken from $maklumat is failed too..
but no error appears...
should i change my SQL statement?

 
Old January 15th, 2004, 04:41 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 836
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What is 'display_errors' set to in php.ini?


Take care,

Nik
http://www.bigaction.org/
 
Old January 17th, 2004, 12:44 AM
Authorized User
 
Join Date: Jan 2004
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default

fo r more details about my problem here pls click this link...
http://forums.devnetwork.net/viewtopic.php?t=16750
untuil now i cannot solve my problem...

 
Old January 17th, 2004, 04:01 AM
Authorized User
 
Join Date: Jan 2004
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default

quasediila5...
i have to post here...
i dont want u to have any conflict with mcgruff at devnet...
ok..i changed back my code like u said...
guess what,this time the UPDATE query is failed....:(

pls check my code,i put the method,the post,the hidden field..

on semakAduan.php:
Code:
<?php
include("../inc/config.php");
?>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<form name="myform" action="semakAduan1.php" method="post">
  <table width="100%" border="1" bgcolor="#FF9900" bordercolor="#333333" align="center">
    <tr> 
      <td align="center" bgcolor="#FFCC00"> <b> 
        MODUL SENARAI PAPARAN ADUAN KEROSAKAN YANG BELUM 
        DI BAIKPULIH </b> </td>
  </tr>
</table>
<br>
<?
function query($query, $line, $file)
{
$result = mysql_query($query);
      if (empty($result) && ini_get('display_errors') == 1)
        {
            echo mysql_error().": ";
            echo mysql_errno()."<br />\n";
            echo $query."<br />\n";
            echo "@ $line in $file\n";
        }
return $result;
}
?>

<?
//***********PANGGIL DATA DARIPADA PANGKALAN DATA******
$result=query("Select * from aduankerosakan where status = 'Baru' ", __LINE__, __FILE__);
$senarai=result;
if (empty($senarai)) 
{ 
?>

<br>
<table width="100%" border="0"align="center">
  <tr> 
    <td align="center">
      <b>
      Maaf ! Tiada maklumat di dalam pangkalan data
      </b>
    </td>
  </tr>
</table>
<P><BR>

<?
    }
else {
?>



  <TABLE BORDER="1" WIDTH="100%" BGCOLOR="#FFFFFF" align=center cellPadding=1 cellSpacing=1 borderColor=black height=1 style="HEIGHT: 1px">
    <TR ALIGN="CENTER">
      <TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <strong> 
        Bil </strong> </TD>
      <TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <strong> 
        ID Aduan </strong> </TD>
      <TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <strong> 
        Tarikh Aduan </strong> </TD>
      <TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <strong> 
        Waktu Aduan </strong> </TD>
      <TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <strong> 
        ID Major </strong> </TD>
      <TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <strong> 
        Punca </strong> </TD>
      <TD ALIGN="CENTER" BGCOLOR="#FFCC00"> <strong> 
        Status </strong> </TD>
    </TR>
<?
$bil=1;
while ($senarai = mysql_fetch_array($result, MYSQL_ASSOC))
{
?>
    <TR>
      <TD><?=$bil?></TD>
      <TD><a href="semakAduan1.php?id=<?=$senarai["idAduan"]?>"><?=$senarai["idAduan"]?></a></TD> 
      <TD><?=$senarai["tarikhAduan"]?></TD>
      <TD><?=$senarai["waktuAduan"]?></TD>
      <TD><?=$senarai["idMajor"]?></TD>
      <TD><?=$senarai["punca"]?></TD>
      <TD><?=$senarai["status"]?></TD>
     </TR>


<?
$bil=$bil+1;
}
?>
</table>
<?
}
?>
<P><BR>
<input type="hidden" name="ruj" value=id>
</form>
<pre><?php
print_r($_POST); // print_r()
?></pre> 
</BODY>
</HTML>
is my hidden field is true??i dont feel nice about that...

on semakAduan1.php:

Code:
<?php
extract($_GET); 
include("../inc/config.php");
include("../inc/veryuseful.inc");



 function query($query, $link, $line, $file)
{
    $result = mysql_query($query);
      if (empty($result) && ini_get('display_errors') == 1)
        {
            echo mysql_error().": ";
            echo mysql_errno()."<br />\n";
            echo $query."<br />\n";
            echo "@ $line in $file\n";
        }
    return $result;
    }

?>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</head>
<body>
<form name="myform">

<?php
//'{$_GET["id"]}'
   $status= "Diproses";
   $jenis="BM";
    $masuk = mysql_query("UPDATE aduankerosakan SET status = '" . $status . "' WHERE idAduan = '" . $_POST['id'] . "'"); 
    $result = query("SELECT * FROM ".$DBprefix." aduankerosakan INNER JOIN tpartminor ON aduankerosakan.idMajor = tpartminor.idMajor WHERE aduankerosakan.idAduan ='" . $_POST['id'] . "'",$link, __LINE__, __FILE__);
    $maklumat = mysql_fetch_array($result, MYSQL_ASSOC);

    //----------------------------------------------------
   //          CAPAI DATA DARIPADA PANGKALAN DATA
   //          NAMA TABLE : PEKERJA  
   //----------------------------------------------------

    $pekerja = query("SELECT * FROM temployee where status = 'BMW'",$link, __LINE__, __FILE__);


   //----------------------------------------------------
   //          CAPAI DATA DARIPADA PANGKALAN DATA
   //          NAMA TABLE : tpartminor
   //----------------------------------------------------

    $komponen = query("SELECT * FROM tpartminor",$link, __LINE__, __FILE__);
    //----------------------------------------------------------------------------------------------------------------------------

?>

<table align="center" border="1" width="100%">
<tr>
  <td align="center">

<table width="100%" align="center" border="0">
  <tr>
    <td align="center" width="25%">&nbsp;</td>
    <td align="center" width="50%"><img src="../images/logo.gif" WIDTH="170" HEIGHT="53"></td>
    <td align="center" width="25%">
    <strong>
     TARIKH : &nbsp; <?=$maklumat["tarikhAduan"]?>
    </strong> 
    </td>
  </tr>

</table>
<br>
<table align="center" width="100%">
  <tr>
    <td width="70%">
    <strong>
     BORANG LAPORAN KERJA PEMBAIKAN KEROSAKAN MESIN
    </strong> 
    </td>
    <td align="right">
    <strong>
     NO ID ADUAN : &nbsp; <?=$maklumat["idAduan"]?>
    </strong>     
    </td> 
</table>
<br>
        <table border="1" width="100%">
          <tr> 
            <td width="50%"> 
              <table width="100%" align="center">
                <tr> 
                  <td> <strong> Maklumat Mesin </strong> 
                  </td>
                </tr>
                <tr> 
                  <td>  Nama Aset : CENTRIFUGAL PUMP</td>
                </tr>
                <tr> 
                  <td>  ID Major: &nbsp; 
                    <?=$maklumat["idMajor"]?>
                     </td>
                </tr>
                <tr> 
                  <td>  ID Minor: &nbsp; 
                    <?=$maklumat["idMinor"]?>
                     </td>
                </tr>
                <tr> 
                  <td>  Minor Name: &nbsp; 
                    <?=$maklumat["minorName"]?>
                     </td>
                </tr>
                <tr> 
                  <td>  Stok : &nbsp; 
                    <?=$maklumat["jmlhStok"]?>
                     </td>
                </tr>
              </table>
            </td>
            <td width="50%" rowspan="2"> 
              <p> <strong>Deskripsi Tugas</strong> <br>
                <?=$maklumat["punca"]?></textarea>
              </p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
              <p>&nbsp;</p>
            </td>
          </tr>
        </table>
<br>
<table align="center" width="100%">
  <tr>
    <td width="70%">
    <strong>
     SENARAI KOMPONEN
    </strong> 
    </td>
</table>
<br>
<table border="1" width="100%" cellpadding="0" cellspacing="0">
  <tr>
    <td align="center"><strong>Kod Pekerja</strong></td>
    <td align="center"><strong>Tarikh Mula</strong></td>
    <td align="center"><strong>Masa Mula</strong></td>
    <td align="center"><strong>Tarikh Tamat</strong></td>
    <td align="center"><strong>Masa Tamat</strong></td>
    <td align="center" width="30%"><strong>Nama Komponen</strong></td>
    <td align="center"><strong>Kuantiti</strong></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
<br>

<table border="1" width="100%" cellpadding="0" cellspacing="0">
  <tr>
    <td width="50%">
      <table align="center" width="100%">
        <tr>
          <td><strong>&nbsp;&nbsp;&nbsp;Jumlah Masa Kerosakan</strong></td>
        </tr>
        <tr>
          <td><strong>&nbsp;&nbsp;&nbsp;
          _______Hari ________Jam _________Minit<br>
          </strong></td>
        </tr>
      </table>    
    </td>
    <td width="50%">
    <table align="center" width="100%">
        <tr>
          <td><strong>&nbsp;&nbsp;&nbsp;</strong></td>
        </tr>
    </table>
    </td>
  </tr>
  <tr>
    <td width="100%" colspan="2">
    <p>
     <strong>&nbsp;&nbsp;&nbsp;Maklumat Kerja</strong>
    </p>
    <p>&nbsp;</p>

    <table align="center" width="100%">
     <tr>
      <td width="70%">
        <strong>
          &nbsp;&nbsp;&nbsp;Penyelia Yang Terlibat :__________________________
        </strong> 
      </td>
      <td align="left">
       <strong>
         Tarikh :____________________
    </strong>     
    </td> 
    </table>
    </td>
  </tr>
</table>
<br>
<p>
<strong>
  &nbsp;&nbsp;&nbsp;Kerja Sempurna Disahkan Oleh : 
</strong>     
</p>
<table border="0" width="100%">
  <tr>
    <td width="25%">&nbsp;</td>
    <td width="25%">&nbsp;</td>
    <td width="25%">
    <strong>
         Tarikh Pengesahan
    </strong>
    </td>
    <td width="25%">
    <strong>
         Tandatangan
    </strong> 
    </td>
  </tr>
  <tr>
    <td width="25%">
    <strong>
         Subkontrak
    </strong>
    </td>
    <td width="25%">______________</td>
    <td width="25%">______________</td>
    <td width="25%">______________</td>
  </tr>
  <tr>
    <td width="25%">
    <strong>
         PMSB
    </strong>
    </td>
    <td width="25%">______________</td>
    <td width="25%">______________</td>
    <td width="25%">______________</td>
  </tr>
  <tr>
    <td width="25%">
    <strong>
         Hospital
    </strong>
    </td>
    <td width="25%">______________</td>
    <td width="25%">______________</td>
    <td width="25%">______________</td>
  </tr>
</table>
<br><br>
</td></tr>
</table>


<p align="center">
  <strong>
    * Sila cetak dan simpan salinan laporan kerja ini untuk proses penyimpanan maklumat kerosakan 
    dan pengesahan... 
  </strong>
</p>

<center>
  <a href="javascript:if (window.print != null) { window.print(); } else { alert('Harap Maaf, pelayar anda tidak dapat menyokong fungsi ini. Sila pilih Print daripada menu File.'); }"><b> CETAK</b></a>&nbsp;
  <br><!--
  <a href="../mainframe.htm"><b> KEMBALI</b></a>&nbsp;
-->
</center>
</form>
<pre><?php
print_r($_POST); // print_r()
?></pre> 
</body>
</html>
and i fetched the $maklumat,still shows nothing...


 
Old January 17th, 2004, 04:42 AM
richard.york's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 1,706
Thanks: 0
Thanked 6 Times in 6 Posts
Default

Quote:
quote:
quasediila5...
i have to post here...
i dont want u to have any conflict with mcgruff at devnet...
ok..i changed back my code like u said...
guess what,this time the UPDATE query is failed....
Hey Apek,
Nah, we aren't fighting.. just a small difference of opinion! No worries friend..

OK, I went through your code line by line and adjusted what I felt was wrong with it... Try this out. It *may* have a parse error or two.. . and I did some reformatting so I could read it!

Here is a fantastic text editor:
Download this editor, you will love it!
http://www.crimsoneditor.com

I'm turning in for the night (It's very late here!).. let me know if you have any trouble reading the following which contains the modified code!

I added a couple of comments to explain what I changed. Which is in addition to what I had to say in the other forum. I didn't see your link that said:

<a href='semakAduan1.php?id={$senarai['idAduan']}'>
     {$senarai['idAduan']}
</a>

So you were right to use $_GET in the other form, but there were a couple of major errors there too. You didn't call mysql_fetch_array in the second script. And you aren't passing $link to the query() function, which contains the mysql database link handler.

Alright then enough rambling! Good night!

: )
Rich

Code:
<?php

    // semakAduan.php

    error_reporting(E_ALL);
    ini_set('display_errors', 1); 

    include("../inc/config.php");

    function query($query, $line, $file, $link)
    { 
        $result = mysql_query($query, $link);

        if (empty($result) && ini_get('display_errors') == 1) 
        { 
            echo mysql_error().": "; 
            echo mysql_errno()."<br />\n"; 
            echo $query."<br />\n"; 
            echo "@ $line in $file\n"; 
        } 
        return $result;
    }

 Sorry, the double quotes will cause a parse error..  there may be more!

    echo "
        <html>
            <head>
            </head>
            <body>

            //
            // Omit the <form> tags since they don't do anything
            //

                <table width='100%' border='1' bgcolor='#FF9900' bordercolor='#333333' align='center'> 
                    <tr> 
                        <td align='center' bgcolor='#FFCC00'> 
                            <b>
                                MODUL SENARAI PAPARAN ADUAN KEROSAKAN YANG BELUM DI BAIKPULIH
                            </b>
                        </td> 
                    </tr>
                </table>
                <br />\n";

                //***********PANGGIL DATA DARIPADA PANGKALAN DATA******

                $result = query("SELECT * FROM aduankerosakan WHERE status = 'Baru'", __LINE__, __FILE__, $link);

                // This doesn't do anything
                // And will make $senarai ALWAYS be unempty.  So empty will always return false
                // $senarai=result; 

                if (empty($result)) 
                { 
                    echo "<br />
                    <table width='100%' border='0' align='center'> 
                        <tr> 
                            <td align='center'> 

                                    <b> 
                                        Maaf ! Tiada maklumat di dalam pangkalan data 
                                    </b>

                            </td> 
                        </tr> 
                    </table> 
                    <P><BR>\n";
                }

                else
                {
                    echo "


                    <TABLE BORDER='1' WIDTH='100%' BGCOLOR='#FFFFFF' align='center' cellPadding='1' cellSpacing='1' borderColor='black' height='1'> 
                    <TR ALIGN='CENTER'> 
                        <TD ALIGN='CENTER' BGCOLOR='#FFCC00'> <strong> 
                            Bil </strong>
                        </TD> 
                        <TD ALIGN='CENTER' BGCOLOR='#FFCC00'> <strong> 
                            ID Aduan </strong>
                        </TD> 
                        <TD ALIGN='CENTER' BGCOLOR='#FFCC00'> <strong> 
                            Tarikh Aduan </strong>
                        </TD> 
                        <TD ALIGN='CENTER' BGCOLOR='#FFCC00'> <strong> 
                            Waktu Aduan </strong>
                        </TD> 
                        <TD ALIGN='CENTER' BGCOLOR='#FFCC00'> <strong> 
                            ID Major </strong>
                        </TD> 
                        <TD ALIGN='CENTER' BGCOLOR='#FFCC00'><strong> 
                            Punca </strong>
                        </TD> 
                        <TD ALIGN='CENTER' BGCOLOR='#FFCC00'> <strong> 
                            Status </strong>
                        </TD>
                    </TR>\n";


                    for ($bil = 1; $senarai = mysql_fetch_array($result, MYSQL_ASSOC); $bil++)
                    {
                        echo "
                                <TR>
                                    <TD>{$bil}</TD> 
                                    <TD>
                                        <a href='semakAduan1.php?id={$senarai['idAduan']}'>
                                            {$senarai['idAduan']}
                                        </a>
                                    </TD> 
                                    <TD>{$senarai['tarikhAduan']}</TD> 
                                    <TD>{$senarai['waktuAduan']}</TD> 
                                    <TD>{$senarai['idMajor']}</TD>
                                    <TD>{$senarai['punca']}</TD> 
                                    <TD>{$senarai['status']}</TD> 
                                </TR>\n";
                    }


                    echo "                    </table>\n";

                } 

                echo "<P>\n<BR>\n</BODY>\n</HTML>\n";

?>


<?php

    // semakAduan1.php

    // ERROR REPORTING should be turned up all the way!

    error_reporting(E_ALL);
    ini_set('display_errors', 1); 

    include("../inc/config.php"); 
    include("../inc/veryuseful.inc");

    // $link refers to the MySQL link resource handler!
    // Use the variable you use in $link = mysql_connect() here!

    function query($query,$line, $file, $link) 
    { 
        $result = mysql_query($query, $link);

            if (empty($result) && ini_get('display_errors') == 1) 
            { 
                echo mysql_error().": "; 
                echo mysql_errno()."<br />\n"; 
                echo $query."<br />\n"; 
                echo "@ $line in $file\n"; 
            }

       return $result; 
    }

    echo "<html>\n";
    echo "    <head>\n";
    echo "    </head>\n";
    echo "    <body>\n";

        // Omit the form tag since it doesn't do anything


        $status= "Diproses"; 
        $jenis="BM";

        $result = query("UPDATE aduankerosakan SET status = '{$status}' WHERE idAduan = '{$_GET['id']}'", __LINE__, __FILE__, $link);
   
            if (!empty($result))
       
                echo "UPDATE query successful! \$_GET['id'] = {$_GET["id"]}";

            else

                echo "UPDATE query failed!  \$_GET['id'] = {$_GET["id"]}";
   

        $result = query("SELECT * FROM aduankerosakan INNER JOIN tpartminor ON aduankerosakan.idMajor = tpartminor.idMajor WHERE aduankerosakan.idAduan ='{$_POST['id']}'", __LINE__, __FILE__, $link);
   
            // Fetch the results!

            $maklumat = mysql_fetch_array($result, MYSQL_ASSOC);


            //---------------------------------------------------- 
            //          CAPAI DATA DARIPADA PANGKALAN DATA 
            //          NAMA TABLE : PEKERJA  
            //---------------------------------------------------- 

           $pekerja = query("SELECT * FROM temployee where status = 'BMW'", __LINE__, __FILE__, $link);
       

           //---------------------------------------------------- 
           //          CAPAI DATA DARIPADA PANGKALAN DATA 
           //          NAMA TABLE : tpartminor 
           //---------------------------------------------------- 

        $komponen = query("SELECT * FROM tpartminor", __LINE__, __FILE__, $link); 


        echo "
        <table align='center' border='1' width='100%'> 
        <tr> 
          <td align='center'> 

        <table width='100%' align='center' border='0'> 
          <tr> 
            <td align='center' width='25%'> </td> 
            <td align='center' width='50%'><img src='../images/logo.gif' WIDTH='170' HEIGHT='53'></td> 
            <td align='center' width='25%'> 
            <strong> 
             TARIKH :   {$maklumat['tarikhAduan']} 
            </strong> 
            </td> 
          </tr> 

        </table> 
        <br> 
        <table align='center' width='100%'> 
          <tr> 
            <td width='70%'> 
            <strong> 
             BORANG LAPORAN KERJA PEMBAIKAN KEROSAKAN MESIN 
            </strong> 
            </td> 
            <td align='right'> 
            <strong> 
             NO ID ADUAN :   {$maklumat['idAduan']} 
            </strong>      
            </td> 
        </table> 
        <br> 
                <table border='1' width='100%'> 
                  <tr> 
                    <td width='50%'> 
                      <table width='100%' align='center'> 
                        <tr> 
                          <td> <strong> Maklumat Mesin </strong> 
                          </td> 
                        </tr> 
                        <tr> 
                          <td>  Nama Aset : CENTRIFUGAL PUMP</td> 
                        </tr> 
                        <tr> 
                          <td>  ID Major:   
                            {$maklumat['idMajor']} 
                             </td> 
                        </tr> 
                        <tr> 
                          <td>  ID Minor:   
                            {$maklumat['idMinor']} 
                             </td> 
                        </tr> 
                        <tr> 
                          <td>  Minor Name:   
                            {$maklumat['minorName']} 
                             </td> 
                        </tr> 
                        <tr> 
                          <td>  Stok :   
                            {$maklumat['jmlhStok']} 
                             </td> 
                        </tr> 
                      </table> 
                    </td> 
                    <td width='50%' rowspan='2'> 
                      <p> <strong>Deskripsi Tugas</strong> <br> 
                        {$maklumat['punca']}</textarea> 
                      </p> 
                      <p> </p> 
                      <p> </p> 
                      <p> </p> 
                    </td> 
                  </tr> 
                </table> 
        <br> 
        <table align='center' width='100%'> 
          <tr> 
            <td width='70%'> 
            <strong> 
             SENARAI KOMPONEN 
            </strong> 
            </td> 
        </table> 
        <br> 
        <table border='1' width='100%' cellpadding='0' cellspacing='0'> 
          <tr> 
            <td align='center'><strong>Kod Pekerja</strong></td> 
            <td align='center'><strong>Tarikh Mula</strong></td> 
            <td align='center'><strong>Masa Mula</strong></td> 
            <td align='center'><strong>Tarikh Tamat</strong></td> 
            <td align='center'><strong>Masa Tamat</strong></td> 
            <td align='center' width='30%'><strong>Nama Komponen</strong></td> 
            <td align='center'><strong>Kuantiti</strong></td> 
          </tr> 
          <tr> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
          </tr> 
          <tr> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
          </tr> 
          <tr> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
          </tr> 
          <tr> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
            <td> </td> 
          </tr> 
        </table> 
        <br> 

        <table border='1' width='100%' cellpadding='0' cellspacing='0'> 
          <tr> 
            <td width='50%'> 
              <table align='center' width='100%'> 
                <tr> 
                  <td><strong>   Jumlah Masa Kerosakan</strong></td> 
                </tr> 
                <tr> 
                  <td><strong>    
                  _______Hari ________Jam _________Minit<br> 
                  </strong></td> 
                </tr> 
              </table>    
            </td> 
            <td width='50%'> 
            <table align='center' width='100%'> 
                <tr> 
                  <td><strong>   </strong></td> 
                </tr> 
            </table> 
            </td> 
          </tr> 
          <tr> 
            <td width='100%' colspan='2'> 
            <p> 
             <strong>   Maklumat Kerja</strong> 
            </p> 
            <p> </p> 

            <table align='center' width='100%'> 
             <tr> 
              <td width='70%'> 
                <strong> 
                     Penyelia Yang Terlibat :__________________________ 
                </strong> 
              </td> 
              <td align='left'> 
               <strong> 
                 Tarikh :____________________ 
            </strong>      
            </td> 
            </table> 
            </td> 
          </tr> 
        </table> 
        <br> 
        <p> 
        <strong> 
             Kerja Sempurna Disahkan Oleh : 
        </strong>      
        </p> 
        <table border='0' width='100%'> 
          <tr> 
            <td width='25%'> </td> 
            <td width='25%'> </td> 
            <td width='25%'> 
            <strong> 
                 Tarikh Pengesahan 
            </strong> 
            </td> 
            <td width='25%'> 
            <strong> 
                 Tandatangan 
            </strong> 
            </td> 
          </tr> 
          <tr> 
            <td width='25%'> 
            <strong> 
                 Subkontrak 
            </strong> 
            </td> 
            <td width='25%'>______________</td> 
            <td width='25%'>______________</td> 
            <td width='25%'>______________</td> 
          </tr> 
          <tr> 
            <td width='25%'> 
            <strong> 
                 PMSB 
            </strong> 
            </td> 
            <td width='25%'>______________</td> 
            <td width='25%'>______________</td> 
            <td width='25%'>______________</td> 
          </tr> 
          <tr> 
            <td width='25%'> 
            <strong> 
                 Hospital 
            </strong> 
            </td> 
            <td width='25%'>______________</td> 
            <td width='25%'>______________</td> 
            <td width='25%'>______________</td> 
          </tr> 
        </table> 
        <br><br> 
        </td></tr> 
        </table> 


        <p align='center'> 
          <strong> 
            * Sila cetak dan simpan salinan laporan kerja ini untuk proses penyimpanan maklumat kerosakan 
            dan pengesahan... 
          </strong> 
        </p> 

        <center> 
          <a href='javascript:if (window.print != null) { window.print(); } else { alert('Harap Maaf, pelayar anda tidak dapat menyokong fungsi ini. Sila pilih Print daripada menu File.'); }'><b> CETAK</b></a>  
          <br><!-- 
          <a href='../mainframe.htm'><b> KEMBALI</b></a>  
        --> 
        </center> 
        </body> 
        </html>";

?>


:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::
 
Old January 18th, 2004, 09:04 AM
Authorized User
 
Join Date: Jan 2004
Posts: 33
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanx quasedilla5..
its working now.....:D

 
Old January 18th, 2004, 03:20 PM
richard.york's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 1,706
Thanks: 0
Thanked 6 Times in 6 Posts
Default

Apek, glad to here you have it working...

The important question is do you understand why it works??

: )
Rich

:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::





Similar Threads
Thread Thread Starter Forum Replies Last Post
join dhara_adh SQL Server 2000 2 January 2nd, 2007 12:39 AM
Join or not join madhukp SQL Server 2000 3 February 2nd, 2005 01:11 AM
More than one join jaywhy13 Classic ASP Basics 2 January 31st, 2005 11:38 PM
INNER JOIN msmagied Classic ASP Databases 3 August 29th, 2004 12:28 PM
Oracle 8i inner join and left join problem puteri_84 Oracle 2 August 19th, 2004 07:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.