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.