Make a ListBox

[natalieG]

In our script, we are trying to make a list box. The browser
does not show the options. The box shows up, just no items. We did check
that the right number pf rows are in the table and if we change the
statement echoing the  option[Line 4] to just  echo $SPNAME, they display correctly.

Thanks,

NatalieG 

echo '<select name="USER">';
while ($LBOXROW=mysql_fetch_array($LBOXFIND,MYSQL_ASSOC)){
$SPNAME=$LBOXROW[SPNAME];
echo "<option value=\"$SPNAME\"></option>\n";
}//while
echo '</select>';

[micah1701]

change
echo "<option value=\"$SPNAME\"></option>\n";

to

echo "<option value=\"$SPNAME\">\"$SPNAME\"</option>\n";

this is more of an HTML issue then anything else :-)