Re: spamfree@blueyonder.co.uk
| From: | Niel Archer | Date: | Sun, 13 May 2007 12:35:58 +0000 |
| Subject: | Re: spamfree@blueyonder.co.uk | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-27886@lists.php.net to get a copy of this message | ||
> 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