Dynamically display values in dropdown box and then show the selected values as selected by the user which is already stored in the DB

The below code was posted in one of your query on (April 28, 2010 at 4:48 PM) when I tried this code it is adding one more value to the dropdown box and showing as selected. so if I have 5 values in the dropdown this selected one is added as 6th values.

Can you please help me to show more than one value as selected pulling those selected values directly from the Database and not adding to it as an extra one, this is a update screen where user can go and reselect those values..... plz help

Thank you and appreciate

String value=request.getParameter("value");

Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root"); st = conn.createStatement(); rs = st.executeQuery("select * from country"); %> --Please Select-- <% while(rs.next()){ %> "><%=rs.getString("countryname")%>

<% if(rs.getString("countryname").equals(value)){%>

<%=value%> <% } } %>

October 11, 2011 at 7:58 AM

Never mind, I found the answer from your previous post itself.

Thanks