Woah... That all was kind of hard to follow. If I were you I'd not switch in and out of PHP so much. It just sprays <? and ?> all over the code and actually runs slower because the PHP interpreter has to start/stop/start/stop. I'm going to clean the code up a bit here. The main thing you'll notice is that once PHP is entered it does not exit until no more dynamic output exists. Then, when standard HTML will do PHP is exited. Also, you seem to want to set a value to the option tags. This is the correct thing to do in your case. The value passed with the value tag is what is sent to the form handler (uni_emp_db.php)
<form method="post" action="uni_emp_db.php"> //I took the ? out. Why do you need it?
<select size="1" name="D1">
<?
//SQL Query
$sql = "SELECT * FROM uni_emp";
mysql_connect("localhost", "root", "") or die("Unable to connect to SQL server");
$max = 0;
$bmax = mysql_db_query("intranet", $sql);
while ($result = mysql_fetch_array($bmax)) {
$FN =$result['Y'];
$LN=$result['MM'];
print("<option value='" . $ID . "'>" . $FN . " " . $LN . "</option>"); //you didn't have a = between value and the value to set
}
mysql_close();
?>
</select></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
That should work. The option lines that are output from the above should look like:
<option value='3424'>Collin K</option>
When this option is selected the value returned by D1 would be 3424.
One last note: PHP doesn't automatically add line breaks and so you need to add them or the whole of the php output will be one really long line. The way to switch to a new line is to add \n to the output. So the line of code which generates the option tag could be switched to:
print("<option value='" . $ID . "'>" . $FN . " " . $LN . "</option>\n");
Pages: 1
Linux Gurus: Drop down box (Read 5687 times)
