<% java.sql.Statement CPstmt = conn.createStatement(); java.sql.ResultSet CPrs = CPstmt.executeQuery("Select * FROM climbpartners ORDER BY post_date DESC"); %>

<% while(CPrs.next()) { String id = CPrs.getString("id"); String name1 = CPrs.getString("name"); String email = CPrs.getString("email"); String location = CPrs.getString("location"); String postDate = CPrs.getString("post_date").substring(0, 10); String profile = CPrs.getString("profile"); %> <%= name1 %> <%= email %> <%=location%>   Posted on: <%=postDate%> <%=profile%> <% } CPrs.close(); CPstmt.close(); %>

Submit your profile