select values for second drop down

Hi All
Can any one help me?
I am trying to select a value from the dynamic drop down and depending upon my selection[i.e. state name] I would like to display all the related cities in the second drop down.
Here is the code:

1 <%@page  import="java.sql.*"%>
      2 <html>
      3 <body>
      4 <% String state = request.getParameter("state"); out.println(state);%>
      5 <form name="my" action="abhay.jsp" method="post">
      6     Country Name:<select value=state onchange="my.submit();">
      7         <%
      8             if(state==null)
      9             {
     10             Connection con = null;
     11             Statement st = null;
     12             ResultSet rs = null;
     13             try
     14             {
     15             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     16             con = DriverManager.getConnection("jdbc:odbc:abhay","root","root");
     17             st = con.createStatement();
     18             String sa="select cname from cname";
     19             rs = st.executeQuery(sa);
     20             while(rs.next())
     21             {
     22                 String y = rs.getString("cname");
     23         %>
     24             <option value="<%= y%>"><%= y%><option>
     25         <%
     26             }
     27              }
     28                 catch(Exception e)
     29                 {
     30                 out.println(e);
     31                 }
     32             }
     33             else
     34             {
     35                  state= request.getParameter("state");
     36                   out.println(state);
     37             }
     38         %>
     39     </select>
     40 </form>
     41 <form name="m">
     42     <%
     43       String h = request.getParameter("state") ;
     44       out.println(h);
     45     %>
     46 </form>
     47 </html>

[BPSouther: Added code tags and fixed encoded chars]
[ August 20, 2007: Message edited by: Ben Souther ]

Your code is pretty much unreadable. Please use UBB code tags to preserve its formatting, and please do not replace < > with lt and gt.

If you have trouble posting code, it's usually becasue you have JavaScript that is filtered: phrases such as: onclick or eval.

Please read this for more information.

So...
What part is giving you trouble?
Since we can't run your code without your database, could you tell us what happens when you run it?
What, if anything, is different from what you're expecting?
[ August 20, 2007: Message edited by: Ben Souther ]

Hi all
I am trying to access all the values of countries from the database.
Depending upon the value I have selected my second drop down list should get populated with all the states from the selected country.
Now depending upon my selection for the second drop down my third drop down should get populated with all the cities of that state.
So I am expecting something like this:
First drop down (Country Name from the database)

Second drop down (State name from the data base where country name = Selected by the user in the first drop down)

Third drop down (City name from the data base where country name = selected by the user in the first drop down && state name = selected by the user in the second drop down