spamfree@xxxxxxxxxxxxxxxx

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

 



Yes I do have dynamic content in my page. 
  I?m attaching the whole code for this page.
   
  <---------------------------------Start----------------------------------------------->
   
  
<?php
  echo "
  <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>
   
  
";
  
echo"
<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>";
$page_title = 'View Existing Data';
include ('./includes/header.html');
   
   
  echo"<form  method='post' action=ved.php'>";
   
   
  include( '../mysql_connect.php' );
  echo"<CENTER>";
include ('./includes/footer.html');
echo"</CENTER>";
     $query = "SELECT   DISTINCT Assign_Engineer FROM  lo_data";
   $result = mysql_query($query);
   
  echo"<center>
<br> <br>"
;
  
echo"<select NAME='R'>";
echo"<option value='NULL'>Choose a Category:</option>
";
   while ($line = mysql_fetch_array($result))
   {
      foreach ($line as $value)
       {
  
         echo"<OPTION value='$value'";
        }
  echo ">$value</OPTION>";
  
   }
  
echo "</SELECT>";
echo"<input  type='submit' name='Submit' value='Submit Data'>";
   
  echo"<br> <br>";
   
   
  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"]."'");
}
echo"<div style='overflow:auto; '>";
echo"
  <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>
  
";
  
while($row = mysql_fetch_array($result))
    {
  echo "<tbody>";
    echo "<tr VALIGN='TOP' ALIGN='CENTER'>";
    echo "<td>" . $row['Ref_No'] ."<br> <H3>
 <A HREF='page1.html' onClick='return toggleMenu('menu1')'>Update The Record</A>
</H3>
<SPAN ID='menu1'>
 <FORM>
    <P>
    <TEXTAREA name='text' rows='10' cols='40'>
      Update the record
    </TEXTAREA>
    <INPUT type='submit' value='Update'><INPUT type='reset'>
    </P>
 </FORM>
  
</SPAN>
  </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>";
  }
  echo "</table>";
echo"</div>";
echo"<br>";
  echo"<br>";
  echo "</form>";
  mysql_close();
  
?>
   
   
  <---------------------------------End----------------------------------------------->





 

       
---------------------------------
You snooze, you lose. Get messages ASAP with AutoCheck
 in the all-new Yahoo! Mail Beta. 

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

  Powered by Linux