Forum Sign UP Login Contact Us
HOME : Forum : SQL and Database : Post New Topic
Request for Dynamic Double Drop Down Menu help.
shaneward
05:29:12 09:11
I work for a wastewater treatment company and am trying to move our service reports to a paperless system. I have set up a service report form that sends information to a table (service_reports) on a MySQL database (sewerman). That works fine. I can currently review a single record but I want to be able to review a record by a given date. So I need a double dropdown select menu where the first selection is of the treatment plant location (Plant_Name) and the second drop down would show dates of service (Date) for the Plant_Name selected in the first drop down menu. When a Date is selected, I would like that record to echo.

Here is my code:
plantfind.php >>> My very basic record lookup with the names hard coded. I would like this to be dynamic from MySQL.

<?php
$q=$_GET["q"];

$con = mysql_connect("00.00.000.000","sewerman","********");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("sewerman", $con);

$sql="SELECT * FROM service_reports WHERE Plant_Name = '".$q."'";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<b>Compay Name:</b> ".$row['Company_Name'] .".<br />";
echo "<b>Date Of Service:</b> ".$row['Date'] .".<br />";
echo "<b>Plant Name:</b> ".$row['Plant_Name'] .".<br />";
echo "<b>Plant Address:</b> ".$row['Plant_Address'] .".<br />";
echo "<b>Plant City:</b> ".$row['Plant_City'] .".<br />";
echo "<b>Plant State:</b> ".$row['Plant_State'] .".<br />";
echo "<b>Plant Contact:</b> ".$row['Plant_Contact'] .".<br />";
echo "<b>Plant_Phone:</b> ".$row['Plant_Phone'] .".<br />";
echo "<b>Plant E-mail:</b> ".$row['Plant_Email'] .".<br />";
echo "<b>Bar Screen Condition:</b> ".$row['Bar_Screen_Condit'] .".<br />";
echo "<b>Bar Screen Description:</b> ".$row['Bar_Screen_Descrip'] .".<br />";
echo "<b>Aeration Color:</b> ".$row['Aer_Basin_Color'] .".<br />";
echo "<b>Aer Basin Description:</b> ".$row['Aer_Basin_Descrip'] .".<br />";
echo "<b>Aer Delivery Description:</b> ".$row['Aer_Delivery_Descrip'] .".<br />";
echo "<b>Sludge Return Rate:</b> ".$row['Sludge_Rate'] .".<br />";
echo "<b>Skimmer Setting:</b> ".$row['Skimmer_Setting'] .".<br />";
echo "<b>Skimmer Description:</b> ".$row['Skimmer_Descrip'] .".<br />";
echo "<b>Sludge In Cone (IN.):</b> ".$row['Sludge_In_Cone'] .".<br />";
echo "<b>Clarifier Surface:</b> ".$row['Clarifier_Surface'] .".<br />";
echo "<b>Clarifier Surface Description:</b> ".$row['Clarifier_Surf_Descrip'] .".<br />";
echo "<b>Clarifier Window Condition:</b> ".$row['Clarifier_Window'] .".<br />";
echo "<b>Clarifier Window Description:</b> ".$row['Clarifier_Win_Descrip'] .".<br />";
echo "<b>Clarifier Weir Condition:</b> ".$row['Clarifier_Weir'] .".<br />";
echo "<b>Clarifier Weir Description:</b> ".$row['Clarifier_Weir_Descrip'] .".<br />";
echo "<b>Contact Chamber Condition:</b> ".$row['Contact_Chamber'] .".<br />";
echo "<b>Contact Chamber Obstruction:</b> ".$row['Contact_Obstruct'] .".<br />";
echo "<b>Contact Chamber Obstruction Description:</b> ".$row['Contact_Obstruct_Descrip'] .".<br />";
echo "<b>Contact Chamber Integrity Description:</b> ".$row['Contact_Integrity_Descrip'] .".<br />";
echo "<b>Chlorinator Condition:</b> ".$row['Chlorinator_Condit'] .".<br />";
echo "<b>Chlorine Tube #1 Condition:</b> ".$row['Chlorine1_Condit'] .".<br />";
echo "<b>Chlorine Tube #2 Condition:</b> ".$row['Chlorine2_Condit'] .".<br />";
echo "<b>Chlorine Tube #3 Condition:</b> ".$row['Chlorine3_Condit'] .".<br />";
echo "<b>Chlorine Tube #4 Condition:</b> ".$row['Chlorine4_Condit'] .".<br />";
echo "<b>Chlotinator Description:</b> ".$row['Chlotinator_Descrip'] .".<br />";
echo "<b>Blower(s) Description:</b> ".$row['Blowers_Descrip'] .".<br />";
echo "<b>Filter Housing #1 Condition:</b> ".$row['Filter1_House_Condit'] .".<br />";
echo "<b>Filter Housing #2 Condition:</b> ".$row['Filter2_House_Condit'] .".<br />";
echo "<b>Filter Housing #1 Model:</b> ".$row['Filter1_House_Model'] .".<br />";
echo "<b>Filter Housing #2 Model:</b> ".$row['Filter2_House_Model'] .".<br />";
echo "<b>Filter Element #1 Condition:</b> ".$row['Filter1_Element_Condit'] .".<br />";
echo "<b>Filter Element #2 Condition:</b> ".$row['Filter2_Element_Condit'] .".<br />";
echo "<b>Filter Element #1 Changed:</b> ".$row['Filter1_Element_Change'] .".<br />";
echo "<b>Filter Element #2 Changed:</b> ".$row['Filter2_Element_Change'] .".<br />";
echo "<b>Filter Element #1 Model:</b> ".$row['Filter1_Element_Model'] .".<br />";
echo "<b>Filter Element #2 Model:</b> ".$row['Filter2_Element_Model'] .".<br />";
echo "<b>Pulley Wheel #1 Condition:</b> ".$row['Pulley1_Condit'] .".<br />";
echo "<b>Pulley Wheel #2 Condition:</b> ".$row['Pulley2_Condit'] .".<br />";
echo "<b>V-belt #1 Condition:</b> ".$row['Vbelt1_Condit'] .".<br />";
echo "<b>V-belt #2 Condition:</b> ".$row['Vbelt2_Condit'] .".<br />";
echo "<b>V-belt #1 Model:</b> ".$row['Vbelt1_Model'] .".<br />";
echo "<b>V-belt #2 Model:</b> ".$row['Vbelt2_Model'] .".<br />";
echo "<b>V-belt Description:</b> ".$row['Vbelt_Descrip'] .".<br />";
echo "<b>Motor Pulley #1 Condition:</b> ".$row['Motor_Pulley1_Condit'] .".<br />";
echo "<b>Motor Pulley #2 Condition:</b> ".$row['Motor_Pulley2_Condit'] .".<br />";
echo "<b>Motor Pulley Description:</b> ".$row['Motor_Pulley_Descrip'] .".<br />";
echo "<b>Motor Horse Power:</b> ".$row['Motor_HP'] .".<br />";
echo "<b>Motor Voltage:</b> ".$row['Motor_Volts'] .".<br />";
echo "<b>Motor Phase:</b> ".$row['Motor_Phase'] .".<br />";
echo "<b>Motor Condition:</b> ".$row['Motor_Condit'] .".<br />";
echo "<b>Motor #1 Amps:</b> ".$row['Motor1_Amps'] .".<br />";
echo "<b>Motor #2 Amps:</b> ".$row['Motor2_Amps'] .".<br />";
echo "<b>Control Panel Condition:</b> ".$row['Control_Condit'] .".<br />";
echo "<b>Audible Alarm Condition:</b> ".$row['Audible_Alarm'] .".<br />";
echo "<b>Visual Alarm Condition:</b> ".$row['Visual_Alarm'] .".<br />";
echo "<b>Effluent Clarity:</b> ".$row['Effluent_Clarity'] .".<br />";
echo "<b>Effluent Odor:</b> ".$row['Effluent_Odor'] .".<br />";
echo "<b>Flow Rate:</b> ".$row['Flow_Rate'] .".<br />";
echo "<b>pH Measurement:</b> ".$row['pH_Measurement'] .".<br />";
echo "<b>Chlorine Residual:</b> ".$row['CL2_Residual'] .".<br />";
echo "<b>Effluent Notes:</b> ".$row['Effluent_Notes'] .".<br />";
echo "<b>Chlorine Bucket #:</b> ".$row['CL2_Bucket'] .".<br />";
echo "<b>Operator Performing Service:</b> ".$row['Service_Operator'] .".<br />";
echo "</tr>";
echo "</table>";
}
mysql_close($con);
?>

- - - - - - - - - - - - - - - - - - - - - - - - - - -
Here is my html form: plantfind.html Again, my menu is hard coded but needs to be dynamic from MySQL

<html>
<head>
<title>SEWERMAN, LLC Treatment Plant Service Report</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<style type="text/css">

/* General styles */
body { margin: 0; padding: 0; font: 80%/1.5 Arial,Helvetica,sans-serif; color: #111; background-color: #FFF; }
h2 { margin: 0px; padding: 10px; font-family: Georgia, "Times New Roman", Times, serif; font-size: 200%; font-weight: normal; color: #FFF; background-color: #111; border-bottom: #BBB 2px solid; }
p#copyright { margin: 20px 10px; font-size: 90%; color: #999; }

/* Form styles */
div.form-container { margin: 10px; padding: 5px; background-color: #FFF; border: #EEE 1px solid; }

p.legend { margin-bottom: 1em; }
p.legend em { color: #C00; font-style: normal; }

div.errors { margin: 0 0 10px 0; padding: 5px 10px; border: #FC6 1px solid; background-color: #FFC; }
div.errors p { margin: 0; }
div.errors p em { color: #C00; font-style: normal; font-weight: bold; }

div.form-container form p { margin: 0; }
div.form-container form p.note { margin-left: 170px; font-size: 90%; color: #333; }
div.form-container form fieldset { margin: 10px 0; padding: 10px; border: #DDD 1px solid; }
div.form-container form legend { font-weight: bold; color: #666; }
div.form-container form fieldset div { padding: 0.25em 0; }
div.form-container label,
div.form-container span.label { margin-right: 10px; padding-right: 10px; width: 150px; display: block; float: left; text-align: right; position: relative; }
div.form-container label.error,
div.form-container span.error { color: #C00; }
div.form-container label em,
div.form-container span.label em { position: absolute; right: 0; font-size: 120%; font-style: normal; color: #C00; }
div.form-container input.error { border-color: #C00; background-color: #FEF; }
div.form-container input:focus,
div.form-container input.error:focus,
div.form-container textarea:focus { background-color: #FFC; border-color: #FC6; }
div.form-container div.controlset label,
div.form-container div.controlset input { display: inline; float: none; }
div.form-container div.controlset div { margin-left: 170px; }
div.form-container div.buttonrow { margin-left: 180px; }

/* Table Styles */
table, th, td
{
border: 1px solid black;
}
table
{
border-collapse:collapse;
}
table,th, td
{
border: 1px solid black;
}
table
{
width:80%;
}
th
{
height:40px;
}
td
{
text-align:left;
}
td
{
height:40px;
vertical-align:bottom;
}
td
{
padding:10px;
}
table, td, th
{
border:1px solid green;
}
th
{
background-color:green;
color:white;
}


</style>

<script type="text/javascript">
function showUser(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","plantfind.php?q="+str,true);
xmlhttp.send();
}
</script>
</head>
<body>
<div id="wrapper">

<h2><img src="/INSTALLERS/Sewerman/images/SM_logo.jpg" alt="SewerMan" /> Treatment Plant Service Report</h2>

<div class="form-container">

<p>Return to: <a href="allreports.html" title="SEWERMAN, LLC Reports Home">Service Reports Home</a>.</p>
<h3>Select your <b>parish</b> below:</h3>

<form>
<select name="users" onchange="showUser(this.value)">
<option value="">Select...</option>
<option value="Wisteria Heights MHP">Wisteria Heights MHP</option>
<option value="Country Manor MHP">Country Manor MHP</option>
<option value="X">X</option>
<option value="Y">Y</option>
<option value="Z">Z</option>
</select>
</form>
<br />
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f10; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f12; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f13; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f14; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f15; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f16; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f17; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f18; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f19; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f20; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f21; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f22; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f23; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f24; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f25; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f26; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f27; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f28; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f29; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f30; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f31; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f32; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f33; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f34; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f35; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f36; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f37; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f38; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f39; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f40; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f41; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f42; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f43; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f44; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f45; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f46; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f47; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f48; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f49; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f50; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f51; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f52; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f53; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f54; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f55; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f56; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f57; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f58; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f59; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f60; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f61; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f62; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f63; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f64; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f65; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f66; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f67; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f68; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f69; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f70; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f71; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f72; ?></font></td>
</tr>

<div id="txtHint"><a name="Installer Finder Results:"></a></div>
<div id="txtHint"><a name="Reset Selection"></a></div>




<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"Company Name");
$f2=mysql_result($result,$i,"Company Name");
$f3=mysql_result($result,$i,"Plant Name");
$f4=mysql_result($result,$i,"Plant Address");
$f5=mysql_result($result,$i,"Plant City");
$f6=mysql_result($result,$i,"Plant State");
$f7=mysql_result($result,$i,"Plant Contact");
$f8=mysql_result($result,$i,"Plant Phone");
$f9=mysql_result($result,$i,"Plant Email");
$f10=mysql_result($result,$i,"Bar Screen Condition");
$f11=mysql_result($result,$i,"Bar Screen Description");
$f12=mysql_result($result,$i,"Aeration Color");
$f13=mysql_result($result,$i,"Aer Basin Descript.");
$f14=mysql_result($result,$i,"Aer Delivery Descript.");
$f15=mysql_result($result,$i,"Sludge Return Rate");
$f16=mysql_result($result,$i,"Skimmer Setting");
$f17=mysql_result($result,$i,"Skimmer Description");
$f18=mysql_result($result,$i,"Sludge In Cone");
$f19=mysql_result($result,$i,"Clarifier Surface");
$f20=mysql_result($result,$i,"Clarifier Surface Description");
$f21=mysql_result($result,$i,"Clarifier Window Condition");
$f22=mysql_result($result,$i,"Clarifier Window Description");
$f23=mysql_result($result,$i,"Clarifier Weir Condition");
$f24=mysql_result($result,$i,"Clarifier Weir Description");
$f25=mysql_result($result,$i,"Contact Chamber Condition");
$f26=mysql_result($result,$i,"Contact Chamber Obstruction");
$f27=mysql_result($result,$i,"Contact Chamber Obstruction Description");
$f28=mysql_result($result,$i,"Contact Chamber Integrity Description");
$f29=mysql_result($result,$i,"Chlorinator Condition");
$f30=mysql_result($result,$i,"Chlorine Tube #1 Condition");
$f31=mysql_result($result,$i,"Chlorine Tube #2 Condition");
$f32=mysql_result($result,$i,"Chlorine Tube #3 Condition");
$f33=mysql_result($result,$i,"Chlorine Tube #4 Condition");
$f34=mysql_result($result,$i,"Chlotinator Description");
$f35=mysql_result($result,$i,"Blower(s) Description");
$f36=mysql_result($result,$i,"Filter Housing #1 Condition");
$f37=mysql_result($result,$i,"Filter Housing #2 Condition");
$f38=mysql_result($result,$i,"Filter Housing #1 Model");
$f39=mysql_result($result,$i,"Filter Housing #2 Model");
$f40=mysql_result($result,$i,"Filter Element #1 Condition");
$f41=mysql_result($result,$i,"Filter Element #2 Condition");
$f42=mysql_result($result,$i,"Filter Element #1 Changed");
$f43=mysql_result($result,$i,"Filter Element #2 Changed");
$f44=mysql_result($result,$i,"Filter Element #1 Model");
$f45=mysql_result($result,$i,"Filter Element #2 Model");
$f46=mysql_result($result,$i,"Pulley Wheel #1 Condition");
$f47=mysql_result($result,$i,"Pulley Wheel #2 Condition");
$f48=mysql_result($result,$i,"V-belt #1 Condition");
$f49=mysql_result($result,$i,"V-belt #2 Condition");
$f50=mysql_result($result,$i,"V-belt #1 Model");
$f51=mysql_result($result,$i,"V-belt #2 Model");
$f52=mysql_result($result,$i,"V-belt Description");
$f53=mysql_result($result,$i,"Motor Pulley #1 Condition");
$f54=mysql_result($result,$i,"Motor Pulley #2 Condition");
$f55=mysql_result($result,$i,"Motor Pulley Description");
$f56=mysql_result($result,$i,"Motor Horse Power");
$f57=mysql_result($result,$i,"Motor Voltage");
$f58=mysql_result($result,$i,"Motor Phase");
$f59=mysql_result($result,$i,"Motor Condition");
$f60=mysql_result($result,$i,"Motor #1 Amps");
$f61=mysql_result($result,$i,"Motor #2 Amps");
$f62=mysql_result($result,$i,"Control Panel Condition");
$f63=mysql_result($result,$i,"Audible Alarm Condtion");
$f64=mysql_result($result,$i,"Visual Alarm Condition");
$f65=mysql_result($result,$i,"Effluent Clarity");
$f66=mysql_result($result,$i,"Effluent Odor");
$f67=mysql_result($result,$i,"Flow Rate");
$f68=mysql_result($result,$i,"pH Measurement");
$f69=mysql_result($result,$i,"Chlorine Residual");
$f70=mysql_result($result,$i,"Effluent Notes");
$f69=mysql_result($result,$i,"Chlorine Bucket #");
$f70=mysql_result($result,$i,"Operator Performing Service");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f10; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f12; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f13; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f14; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f15; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f16; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f17; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f18; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f19; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f20; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f21; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f22; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f23; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f24; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f25; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f26; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f27; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f28; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f29; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f30; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f31; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f32; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f33; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f34; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f35; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f36; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f37; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f38; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f39; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f40; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f41; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f42; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f43; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f44; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f45; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f46; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f47; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f48; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f49; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f50; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f51; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f52; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f53; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f54; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f55; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f56; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f57; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f58; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f59; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f60; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f61; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f62; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f63; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f64; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f65; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f66; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f67; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f68; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f69; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f70; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f71; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f72; ?></font></td>
</tr>

<?php
$i++;
}
?>
</body>
</html>

- - - - - - - - - - - - - - - - - - -

I thank you in advance for any help or direction you can provide. I am PHP ignorant and bow to your superior knowledge. The Double Drop Down example on this site is great but I don't know how to swithc from looking up number to looking up Plant_Name and Date.

Thanks again,
Shane
Please Login to post your reply or start a new topic
Privacy Policy | Disclaimer
©2000 - 2014 plus2net.com All rights reserved worldwide