Just a small suggestion, if you are going to work with many select boxes in your script, I certainly suggest working with the primary keys that the database call returns. This will make it easier for you if you need to determine actions, or previous selections a user has made based on those numbers. Here's an example:

{
  my $sth = $dbh->prepare("SELECT id, value FROM database");
  my $result = $sth->fethall_arrayref();

  print "<select name=\"selectboxname\"><option></option>";
  for (@$result) {
    print "<option value=\"$_->[0]\">$_->[1]</option>";
  }
  print "</select>";
}
[download]

The above example runs through each result (for loop) and takes the current value of each entry (..row ie. id->1, value=>Selection) and prints the option tag. You can easily check for previously selected options by adding a conditional in the for loop above and test against a previously declared value and adding the "selected" string into your option tags.

You will now have a variable in your session called 'selectboxname' with a number value equivalent to what the user chose from the select.

BlackJudas