|XP is just a number|
Selecting a value on a pull-down menuby rodry (Beadle)
|on Oct 02, 2000 at 21:55 UTC||Need Help??|
rodry has asked for the wisdom of the Perl Monks concerning the following question:
Perhaps the title of this question is not self-explanatory. Here is what I am trying to do.
I wrote a script that generates a form and populates it with data from a Mysql database. I fill in all the <value> tags with the information I pull from the query.
However, some of the fields have a restrictive set of values that I would like the user to select from a pull-down menu (like a list of countries). I do this by using the <select> tag.
Here comes the problem. When I display the data on the menu, it displays only the first value on the list, not the corresponding value I am populating from the query.
I need to find a way to "print" the <selected> attribute of the <option> tag the correct item. The item list itself comes from a table in the database.
I thought about writing a function that was to be called when it was time to display the pull-down menu, but I realized that I would have to destroy the statement handle before the script finished displaying all the data.
Thanks in advance.