Hi I'm trying to access my SQL database choose record and then update it. Basicaly I have PROJECT table
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
<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