<%@ page import="java.sql.*, noire.DbConn, java.util.*" errorPage="" %> <%! Statement st; %>

Litho Posters Size A3 A2 Delivery no yes Quantity Select Qty All <% Statement st=db.getSt(); String q="select distinct qty from posterthree"; ResultSet rs=st.executeQuery(q); while (rs.next()){ out.print(""+rs.getString(1)+""); } %>   <% String q1; String qty=request.getParameter("qty"); String rb1v=request.getParameter("rb1v"); String rb2v=request.getParameter("rb2v"); if (qty!=null){ if (qty.equals("all")){ q1="select qty, price from posterthree where size='"+rb1v+"' and del='"+rb2v+"'"; }else{ q1="select qty, price from posterthree where qty='"+qty+"' and size='"+rb1v+"' and del='"+rb2v+"'"; } ResultSet rs1=st.executeQuery(q1); out.print(""); out.print(""); out.print(""); out.print(""); out.print(""); int i=0; while (rs1.next()){ //out.println(""); if (i%4==0){ out.println(""); out.println(""); }else{ out.println(""); } i++; } } %> Qty 1 Colour 2 Colour 3 Colour 4 Colour "+rs.getString(1)+" "+rs1.getString(1)+" "+rs1.getString(2)+" "+rs1.getString(2)+"