<%
String str2 ="SELECT top 6 movie_id,type_id,movie_name FROM mt_movie_info where ad_sign=1 ORDER BY hits DESC" ;
Rs=conn.executeQuery(str2);
while(Rs.next())
{
int movie_id=Rs.getInt("movie_id");
int typeid=Rs.getInt("type_id");
String movie_name=Rs.getString("movie_name");
%><%
}
Rs.close();%>
<%
String str2 ="SELECT top 6 movie_id,type_id,movie_name FROM mt_movie_info where ad_sign=1 ORDER BY hits DESC" ;
Rs=conn.executeQuery(str2);
while(Rs.next())
{
int movie_id=Rs.getInt("movie_id");
int typeid=Rs.getInt("type_id");
String movie_name=Rs.getString("movie_name");
%><%
}
Rs.close();%>
<%
String str1 ="SELECT top 6 movie_id,type_id,movie_name FROM mt_movie_info ORDER BY movie_id DESC"
;
Rs=conn.executeQuery(str1);
while(Rs.next())
{
int movie_id=Rs.getInt("movie_id");
int typeid=Rs.getInt("type_id");
String movie_name=Rs.getString("movie_name");
%>
