<%@include file="includes/dbConnection.jsp"%> NAAIIP
<%@ include file="includes/Header.jsp"%>
 
<% int num=0; int rc=0; int cnt =0; if ( request.getParameter("rc") != null ) { rc=Integer.parseInt(request.getParameter("rc")); } int n=50; String sqlcnt="select count(*) from chapter_committee"; Statement stcnt=con.createStatement(); ResultSet rscnt=stcnt.executeQuery(sqlcnt); if(rscnt.next()) { cnt=rscnt.getInt(1); } String sqlquery="SELECT chapter_dtls.chapter_name,chapter_dtls.state_id,chapter_committee.name from chapter_dtls inner join chapter_committee on chapter_dtls.chapter_id=chapter_committee.chapter_id limit "+rc+","+n; //Statement st=con.createStatement(); ResultSet rs=st.executeQuery(sqlquery); %>

Chapters

Naaiip Chapter Committee
<% if(cnt>50) { %>


  Records : <%=rc+1%>-<%if (rc+10 > cnt){%><%=cnt%><%}else{%><%=rc+n%><%}%>
<% int g2=0,w2=10,q2=1,k2=1; if (w2>cnt/w2) { w2=cnt/w2+1; } for (k2=1; k2<=cnt/n; k2++) { if (rc/n>=w2) { q2=w2+1; w2=w2+10; } } if (w2*n>cnt) { w2=(cnt/n)+1; } %> <%if (cnt > n) {%>
<%if (rc>(0)) {%>   Previous <%}%> <% for (g2=q2; g2<=w2; g2++) { if ((n*g2)-(n)==rc) { %> <%=g2%> <% }else{%> <%=g2%> <% } } %> <%if (rc+n Next  
<%}%> <%}%>
<% } %>
<% while(rs.next()&&num<50) { %> <% num=num+1; } %>
City
State
Chair

<%=rs.getString("chapter_name")%>
<%=rs.getString("state_id")%>
<%=rs.getString("name")%>

 

<%@ include file="includes/rsidemenu.jsp"%>
<%@ include file="includes/Footer.jsp"%>