%@ page contentType="text/html;charset=utf-8"%>
<%@ page language="java" import="java.net.*" %>
<%@ page language="java" import="java.sql.*" %>
<%@ include file="./include/common.jsp"%>
<%
DBbean.setupConnection("cmbcard");
String sqlStr="select a.*,b.reg_uname from cartoons a left join reg b on b.id = a.uid where a.verified = '1' order by a.id desc limit 3";
ResultSet rs=DBbean.executeQuery(sqlStr);
%>
<%
DBbean.closeConnection();
DBbean.setupConnection("cmbcard");
sqlStr="select a.*,b.reg_uname from cartoons a left join reg b on b.id = a.uid where a.verified = '1' order by a.clicks desc limit 3";
rs=DBbean.executeQuery(sqlStr);
while(rs.next()){
%>