reviewindex.asp

社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功

<!--#include file=include/conn.asp -->
<!--#include file=include/config.asp -->
<!--#include file=include/function.asp -->
<%
dim shu,order,time,path,ss,oo,tt
shu=request.querystring("shu")
order=request("order")
time=request.querystring("time")
title=request.querystring("title")'
Path = "./"
if shu<>"" then   '显示数目，不加为10
ss=shu
else
ss=6
end if
if order="reviewid" then  '排序方式，click为按点击率
oo="UpdateTime"
else
oo="reviewid"
end if
if time="0" then  '显示时间，0为不显示
tt=0
else
tt=1
end if
if title<>"" then   '显示字数数目，不加为10
nn=title
else
nn=20
end if
set rs=conn.execute("SELECT top "&ss&" * FROM Review order by "&oo&" desc")
if rs.eof and rs.bof then %>
     document.write('没有');
  <% else  
do while not rs.eof

title=trim(rs("Content")) '获取表格中留言字段内容并替换格式符
title=replace(title,"<br>","")
title=replace(title,"<P>","")
title=replace(title,"</P>","")
title=replace(title," ","")
if strcomp(gotTopic(title,nn),title)<0 then
%>
<LINK href=news.css rel=stylesheet><br><li><font class=class><A class=class href="<%=path%>readview.asp?reviewID=<%=rs("reviewID")%>" title="<%=title%>" target="_blank"><%=gotTopic(title,nn)%></A><%if tt=1 then%><FONT color="#666666">(<%=month(rs("updatetime"))%>-<%=day(rs("updatetime"))%>)</FONT><%end if%><%if date()-rs("updatetime")<2 then%><FONT color="#ff0000">新！<%end if%></font>
<%else%>
<LINK href=news.css rel=stylesheet><br><li><font class=class><A class=class href="<%=path%>readview.asp?reviewID=<%=rs("reviewID")%>" title="<%=title%>" target="_blank"><%=gotTopic(title,nn)%></A><%if tt=1 then%><FONT color="#666666">(<%=month(rs("updatetime"))%>-<%=day(rs("updatetime"))%>)</FONT><%end if%><%if date()-rs("updatetime")<2 then%><FONT color="#ff0000">新！</FONT><%end if%></font>
<%
end if
rs.movenext 
loop 
end if
Rs.Close
set Rs=nothing
%>