<%
MaxPageSize=10
set rs=server.createobject("Adodb.recordset")
sql = "select *,body_polls+body_smspoll as body_polls from Active_body where body_isactive=1 and body_classid in (178) order by body_polls desc"
rs.open sql,conn,1,1
if not rs. eof then
SplitPages_starts nowpage,MaxPageSize*4,rs
for i=1 to MaxPageSize
%>
<%
for j=1 to 4
if rs.eof then exit for
bodyid=trim(rs("body_id"))
bodyisactive=trim(rs("body_isactive"))
bodyno=trim(rs("body_no"))
bodyclassid=trim(rs("body_classid"))
bodyorder=trim(rs("body_order"))
bodytitle=trim(rs("body_title"))
bodydesc=trim(rs("body_desc"))
bodycontent=trim(rs("body_content"))
bodyimg=trim(rs("body_img"))
bodyuserold=trim(rs("body_userold"))
bodyusersex=trim(rs("body_usersex"))
bodyuserjob=trim(rs("body_userjob"))
bodyusername=trim(rs("body_username"))
bodyuseremail=trim(rs("body_useremail"))
bodyusercontact=trim(rs("body_usercontact"))
bodyhits=trim(rs("body_hits"))
bodypolls=trim(rs("body_polls"))
bodypoints=trim(rs("body_points"))
bodyaddtime=trim(rs("body_addtime"))
%>
|
|
<%
rs.movenext
next
%>
<%
next
end if
%>