Re: spamfree@xxxxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> I understand, but how about the attached code? Every thing works fine except the slide menu.

  It had errors in it that needed correcting.  Beyond that I can't much
say. It *looks* OK, but without the missing include files it can't be
tested.

  I've restructured it below.  I had to make some guesses about your
intent, mostly about the include files.  Hopefully I've guessed
correctly and not introduced too many errors of my own.
  Note that I've moved most of the HTML outside of the PHP code, as it
does not need to be parsed.  I've also standardised it as much as
possible in an attempt to make it clearer.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";>
<HTML>
  <HEAD>
    <SCRIPT TYPE="TEXT/JAVASCRIPT" LANGUAGE="JAVASCRIPT">
      <!-- Hide script from older browsers
        function toggleMenu(currMenu) {
          if (document.all) {
            thisMenu = eval('document.all.' + currMenu + '.style')
            if (thisMenu.display == 'lock') {
              thisMenu.display = 'none'
            } else {
              thisMenu.display = 'block'
            }
          return false
          } else {
            return true
          }
        }
      // End hiding script -->
    </SCRIPT>
    <STYLE TYPE="TEXT/CSS">#menu1 {display:none; margin-left:20px}</STYLE>
<?php

$page_title = 'View Existing Data';
//include ('./includes/header.html');
//include( '../mysql_connect.php' );

?>
    <HEAD>
    <BODY>
    <TABLE ALIGN="center" BORDER="0" CELLSPACING="0" CELLPADDING="0">
      <TR ALIGN="center" VALIGN="middle">
        <TH ALIGN="center"><FONT SIZE="6" COLOR ="#310032">View Existing Data</FONT></TH>
      </TR>
    </TABLE>

    <FORM METHOD="post" ACTION="ved.php>">
<?php
$query = "SELECT DISTINCT Assign_Engineer FROM lo_data";
//$result = mysql_query($query);

?>

    <BR /><BR />
    <CENTER>
      <SELECT NAME="R"><OPTION VALUE="NULL">Choose a Category:</OPTION>

<?php

while ($line = mysql_fetch_array($result))
{
    foreach ($line as $value)
    {
        echo"      <OPTION VALUE='$value'</OPTION>";
    }
}

?>
      </SELECT>
      <INPUT  TYPE="submit" NAME="Submit" VALUE="Submit Data"><BR /><BR />
<?php

if (isset($_POST["R"])) {
    $result = mysql_query("SELECT Ref_No, Job_Title,Category,Assign_Engineer,Date_Received,Date_Required,Date_Assigned,ProjectedCompletionDate,Date_Completed,ManhourSpent,Status FROM  lo_data WHERE Assign_Engineer ='".$_POST["R"]."'");
}

?>
      <DIV STYLE="overflow:auto;">
        <TABLE  WIDTH="80" BORDER="1" CELLSPACING="1" CELLPADDING="3" BORDERCOLOR="CDCB98">
          <THEAD>
            <TR STYLE="position: relative; top: expression(this.offsetParent.scrollTop); background-color: #CDCB98;">
              <TH>Reference No</TH>
              <TH>Job Descriptions</TH>
              <TH>Category</TH>
              <TH>Assign Engineer</TH>
              <TH>Date Received</TH>
              <TH>Date Required</TH>
              <TH>Date Assigned</TH>
              <TH>Projected Completion Date</TH>
              <TH>Date Completed</TH>
              <TH>Manhour Spent</TH>
              <TH>Status</TH>
            </TR>
          </THEAD>
<?php

while($row = mysql_fetch_array($result))
{
    echo "<TBODY>";
    echo "<TR VALIGN=\"TOP\" ALIGN=\"CENTER\">";
    echo "<TD>{$row['Ref_No']}<BR />\n<H3><A HREF=\"page1.html\" onClick=\"return toggleMenu('menu1')\">Update The Record</A></H3>\n<SPAN ID=\"menu1\">";
    echo "<FORM>\n<P><TEXTAREA NAME=\"text\" ROWS=\"10\" COLS=\"40\">Update the record</TEXTAREA><INPUT TYPE=\"submit\" VALUE=\"Update\"><INPUT type=\"reset\"></P></FORM>";
    echo "</SPAN>\n</TD>";
    echo "<TD>{$row['Job_Title']}</TD>";
    echo "<TD{$row['Category']}</TD>";
    echo "<TD{$row['Assign_Engineer']}</TD>";
    echo "<TD{$row['Date_Received']}</TD>";
    echo "<TD{$row['Date_Required']}</TD>";
    echo "<TD{$row['Date_Assigned']}</TD>";
    echo "<TD{$row['ProjectedCompletionDate']}</TD>";
    echo "<TD{$row['Date_Completed']}</TD>";
    echo "<TD{$row['ManhourSpent']}</TD>";
    echo "<TD{$row['Status']}</TD>";
    echo "</TR>";
    echo"</TBODY>";
}

?>
        </TABLE>
      </DIV>
    </FORM>
    <BR /><BR />
    <CENTER>
<?php

//mysql_close();
//include ('./includes/footer.html');

?>
    </CENTER>
  </BODY>
</HTML>


Niel

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux