Hi I'm trying to access my SQL database choose record and then update it. Basicaly I have PROJECT table
Code:
TABLE Project (PNAME  varchar(50) not null,

                      DESCR  varchar(50) not null,

                      SKILLS     varchar(50) not null,

                      PRICE number ,                          

                      TYPE         varchar(50) not null)
So I wont to be able to choose by TYPE in drop-down menu and then update it's price
so I'm using this code
Code:
<select name='PNAME' onchange="showState(this.value)">  
  <option value="none">Select</option>  
  <%
 Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance(); 
 Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/Data");  
 Statement stmt = con.createStatement();  
 ResultSet rs = stmt.executeQuery("Select * from PROJECT");
 while(rs.next()){
     %>
 <option value="<%=rs.getString(1)%>"><%=rs.getString(2)%></option>  
 <%
 }
     %>
 </select>  
 <br>  
 <div id='TYPE'>  
 <select name='TYPE' >  
 <option value='-1'></option>  
 </select>  
 </div>
and don't know where to go from here
Thanks