Okay I finally got it working with the hashref function. The problem is that I have all my HTML form data in a huge qq{} block. I can't dynamically populate the pulldown menu within that block.

Here's a snippet:

--

<form name="facultyeval" method="post" action="">

<table width="80%">
<tr>
<td width="24%">
<div align="right"><b>Student's Name:</b></div>
</td>
<td width="76%">
<select name="nameselect" size="1">

while (my $row = $sth->fetchrow_hashref) {
$fld = $row->{firstname};
print $fld;
}


</td>
</tr>
<tr>
<td colspan="2"><b>Question 1</b></td>
</tr>
<tr>
<td colspan="2">How many Quarters have you had this student?
<select name="totalQuar" size="1">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>

--

As you can see I've embedded the code within the qq{} block which does not work. What's the best way to approach this considering I'm printing an enormous form within that black (300+ lines)?

Thanks again yall!

Paul