本站更新

欢迎您参观Go4Go.net推出的新版本网站，这个旧站的内容会逐渐转移过去，请点击这个链接。

最新大赛棋谱

<% sb = new StringBuffer(); //sb.append("SELECT games.Game_ID, games.Game_Date, games.Description, "); //sb.append("p1.Chinese_Name as Black_Name, "); //sb.append("p2.Chinese_Name as White_Name FROM games, players AS p1, players AS p2 "); //sb.append("WHERE games.Black_Player = p1.Player_ID "); //sb.append("and games.White_Player = p2.Player_ID "); //sb.append("ORDER BY games.Game_Date DESC, games.Game_ID DESC LIMIT 20"); sb.append("SELECT g.gameid, g.dt, g.cn_desc, "); sb.append("p1.Chinese_name as Black_Name, "); sb.append("p2.Chinese_name as White_Name "); sb.append("FROM xoops_go4go_games as g, xoops_go4go_players as p1, xoops_go4go_players as p2 "); sb.append("WHERE g.pb = p1.playerid "); sb.append("and g.pw = p2.playerid ORDER BY "); sb.append("g.dt DESC, g.gameid DESC LIMIT 20"); net.go4go.DbBean2 db2 = new net.go4go.DbBean2(); db2.connect(); rs = db2.doQuery(sb.toString()); %> <% while (rs.next()) { %> <%=rs.getString(2)%>  <%=rs.getString(3)%> <%=rs.getString(4)%> -- <%=rs.getString(5)%> <% } %>

更多