I have a drop down list for the users in a table called Members and I want their details displayed in a table on the next page and the option to Update these details.
Is the following the best to use...
Page 1) Page with drop down list with users.
Button to get page with details
Page 2) Users details displayed in text boxes
Button to Update these details
Page 3) Conformation page .... details updated
I'm having a bit of trouble with the 2nd page, inserting the users details in to the text fields from the drop down list.
any ideas with the query
ResultSet rs = statement.executeQuery("SELECT * FROM Member WHERE UserName="+name);