%@ include file="pickanswer_dbConnection.jsp" %>
|
Question Archive
|
|
<%
Statement st9=conn.createStatement();
// SELECT question,sendDate,status,paymentMode,code,questionID FROM Questions where approve='Yes' and questionID ORDER BY questionID DESC LIMIT 0,20
ResultSet rs9=st9.executeQuery("SELECT question,sendDate,status,paymentMode,code,questionID FROM Questions where approve='Yes' and questionID ORDER BY questionID DESC LIMIT 0,50");
%>
<%
while(rs9.next()){
String question =rs9.getString(1);
String sendDate =rs9.getString(2);
String status1 =rs9.getString(3);
String paymentMode=rs9.getString(4);
String code1=rs9.getString(5);
int questionID=rs9.getInt(6);
%>
<% out.print(question); %> <% } %> |
![]() |