i m working on a php page data is getting retrieved from database and everything is working fine except that the retrieved data is not getting passed along the form but all others does. only the data i select in the sql drop down box is not saving.
<html>
<head>
<?php
include('connection.php');
$options = '';
$filter=mysql_query("select distinct username from user");
while($row = mysql_fetch_array($filter)) {
$options .="<option value=".$row['username'].">" . $row['username'] . "</option>";
}
$menu="<form>
<select>
" . $options . "
</select>
</form>";
? >
<title>Bug Report</title>
</head>
<body>
<form action="bugprocess.php" method="get">
<table width="274" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td width="95"><div align="right">name:</div></td>
<td width="171"><input type="text" name="name" /></td>
</tr>
<tr>
<td><div align="right">description:</div></td>
<td><input type="text" name="description" /></td>
</tr>
<tr>
<td><div align="right">priority:</div></td>
<td><select name="priority"><option value="high">high</option>
<option value="low">low</option>
<option value="medium">medium</option>
</select></td>
</tr>
<tr>
<td><div align="right">assign:</div> </td> <td><name="assign"><?php echo $menu?></td>
<td><div align="right"></div></td>
</table>
<br /><center><input name="submit" type="submit" value="Submit" /></td>
</form>
thank you