PHP and Access 2000

[Anon]

Is there a way to create a dropdown menu that is query driven from a Access 2000 database then passed to another form. For example, I want to query a database of supervisors to populate a dropdown on a form, then be able to use that dropdown as needed to update personnel's supervisors. Any help is greatly appreciated.

[amcgrath]

sure.

1. select the data from the database.

2. store it into an array. (looping through the result set using odbc_fetch_row()....)
   (I normally put it in as key = spervisor_id and value = supervisor name)

3. on display do this:
   <?

echo "<select name=\"supervisor_id\">";
while(list($k,$v) = @each($supervisor_list)) {
echo "<option value=\"$k\">$v";
}
echo "</select>";

?>

Now, when the form is submitted, $supervisor_id will be the id number of the chosen supervisor...