Dynamic dropdown list using Access

[john87423]

Hello, I am creating a dropdown list that is populated from an Access DB:

<?php 
	include 'DBConnect.php';

echo "<a href='Users.php'>Users</a><br>";
echo "<a href='FixedBugs.php'>Fixed Bugs</a><br>";
echo "<a href='Printable.php'>Printable</a><br>";

$users = $conn->Execute("SELECT * FROM WebUsers");

$fu1 = $users->Fields("Name");		

//Dropdown  box - dynamic
echo "<select name='users'>";
while(odbc_fetch_row($users)) 
{
	echo "<option value=''>".$fu1->value."</option>";
}
echo "</select>";

The code gives no errors but does not work i.e. nothing in list.

Cheers anyone for ideas why

[john87423]

Solved by me after some work - heres the code for anybody with same problem as I had:

<?php 
	include 'DBConnect.php';

echo "<a href='Users.php'>Users</a><br>";
echo "<a href='FixedBugs.php'>Fixed Bugs</a><br>";
echo "<a href='Printable.php'>Printable</a><br>";

$users = $conn->Execute("SELECT * FROM WebUsers");
$fu1 = $users->Fields("Name");		

echo "<select name='users'>";
while(!$users->EOF) 
{ 
	echo "<option value=".$fu1->value.">".$fu1->value."</option>";

	$users->MoveNext();
} 	
echo "</select>";


echo "<table id='Bugs'>";
echo "<tr bgcolor='66CCCC'><td>Done</td><td>Edit</td><td>Ispriority</td><td>ID</td><td>Code</td><td>Area</td><td>Description</td></tr>";

$records = $conn->Execute("SELECT * FROM BugList WHERE AssignedTo=".$fu1->value."");

while(!$records->EOF) 
{ 
	$fv = $records->Fields("IsPriority");
	$fv1 = $records->Fields("ID");
	$fv2 = $records->Fields("Code");
	$fv3 = $records->Fields("Area");
	$fv4 = $records->Fields("Description");

	echo "<td>".$fv->value."</td>";
	echo "<td>".$fv1->value."</td>";
	echo "<td>".$fv2->value."</td>";
	echo "<td>".$fv3->value."</td>";
	echo "<td>".$fv4->value."</td></tr>";

	$records->MoveNext();
} 
$records->Close(); 

echo "</table>";
?>

This code will not work as I need Javascript to change the table values - dropdwon done though.

Happy coding!