<% HttpSession ss=request.getSession();%>
 <% String tpoemail=(String)ss.getAttribute("temail");%>
 <% String city=request.getParameter("citylist");%>
 <% Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/indiapoolcampus","root","root");%>
<% PreparedStatement pst=(PreparedStatement) con.prepareStatement("select c_reg.code,c_reg.name ,poolcampus.cname,poolcampus.date,poolcampus.position,poolcampus.eligibility from poolcampus natural join c_reg where c_reg.tpoemail=? and c_reg.city=?");%>
<%pst.setString(1,tpoemail); %>
<%pst.setString(2,city); %>
<% ResultSet rs=pst.executeQuery();%>

<% Boolean i=rs.next(); %>


<%if(i){ %>
<table  >

 <% while(rs.next()) { %>
<tr class="alt">
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><%=rs.getString(4) %></td>
<td><%=rs.getString(5) %></td>
<td><%=rs.getString(6) %></td>
<td><a href="#"> Details</a></td>
</tr>

<tr >
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><%=rs.getString(4) %></td>
<td><%=rs.getString(5) %></td>
<td><%=rs.getString(6) %></td>
<td><a href="#"> Details</a></td>
</tr>

<tr class="alt">
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><%=rs.getString(4) %></td>
<td><%=rs.getString(5) %></td>
<td><%=rs.getString(6) %></td>
<td><a href="#">   Details</a></td>
</tr>

<tr>
<td><%=rs.getString(1) %></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
<td><%=rs.getString(4) %></td>
<td><%=rs.getString(5) %></td>
<td><%=rs.getString(6) %></td>
<td><a href="#">   Details</a></td>
</tr>


  <%}%>

  <%}else{ %>
  </table>
  <p><b>No data is available</b></p>
  <%} %>