|
 |
| Media Professionals Registration With Us |
|
| |
|
| Media Professionals Registered with us |
<%
//rs1.beforeLast();
int totalregs1 = Integer.parseInt(rs2.getString("c"));
int total=totalregs1+1;
int tot=totalregs1-40;
//ResultSet rs1=stmt1.executeQuery("select stu_id,stuname,regdate from admission_tab where stu_id between '"+tot+"' and '"+totalregs1 +"' order by regdate desc" );
// ResultSet rs3=stmt3.executeQuery("select newtitle,newadate,newsid from newstab where newsid between '"+tot+"' and '"+total+"' order by newsid desc" );
// ResultSet rs11=stmt1.executeQuery("select top 40 newtitle,newadate from newstab order by newsid desc" );
%>
<%
int hh=1;
//rs1.absolute(hh);
while(rs4.next())
{
//rs1.last();
String nt=rs4.getString("countnews") ;
String newdate=rs4.getString("Category") ;
%>
 <%=newdate%> (<%=nt%>)
<%
ResultSet rs11=stmt1.executeQuery("select top 5 mpid,surname,firstname from MediaProf where Category='"+newdate+"' order by mpid desc" );
while(rs11.next())
{
//rs1.last();
int id=rs11.getInt("mpid");
String newstit=rs11.getString("surname");
String newdat=rs11.getString("firstname") ;
%>
- <%=newdat%> <%=newstit%>
<%
}
%>
<%
if(hh==40)
{
rs4.last();
}
hh=hh+1;
%>
<% } %>
|
<%
//rs1.beforeLast();
//int totalregs1 = Integer.parseInt(rs2.getString("c"));
// int tot=totalregs1-40;
//ResultSet rs1=stmt1.executeQuery("select stu_id,stuname,regdate from admission_tab where stu_id between '"+tot+"' and '"+totalregs1 +"' order by regdate desc" );
//ResultSet rs3=stmt3.executeQuery("select stu_id,stuname,regdate from admission_tab where stu_id between '"+c+"' and '"+d+"' order by regdate desc" );
// ResultSet rs11=stmt1.executeQuery("select top 40 newtitle,newadate from newstab order by newsid desc" );
%>
<%
int limitePorPagina = 40;
int totalpgs = Math.round(totalregs / limitePorPagina);
%>
<%
//out.write("Pýginas: " + totalpgs);
if ((totalregs % limitePorPagina) > 0) totalpgs++;
//int pr = Integer.parseInt(request.getParameter("pr"));
%>
|
<%
for(int i=1 ;i
<%
} %>
|
|
|
TV Studios
