Go News
<%
db.connect();
StringBuffer sb = new StringBuffer();
sb.append("SELECT * FROM englishnews WHERE Event_Date>'2004-08-31' ");
sb.append("ORDER BY Event_Date DESC, ID DESC");
ResultSet rs = db.doQuery(sb.toString());
%>
<%
while (rs.next()) {
%>
2003 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2004 Jan Feb Mar Apr May Jun Jul Aug |
<%=rs.getString(2)%>
<%=rs.getString(3)%>
<%
String refType = rs.getString("Ref_Type");
String link = null;
if (refType.equals("gameID")) {
link = "sgfview.jsp?id="+rs.getString("Ref_ID");
%>
