Yes I do have dynamic content in my page.
Im 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.
