%
keyword=request("keyword")
author=request("author")
if keyword="" and author="" then
response.write("")
response.end
end if
Server.ScriptTimeOut=999999999
if request("page")="" then
page=1
else
page=cint(request("page"))
end if
if author="" then
set rs=server.CreateObject("ADODB.RecordSet")
Sql="select id,title,user_name,submit_time,content,shenhe from content where title like '%"&keyword&"%'"&"and shenhe=1 order by submit_time desc"
rs.open sql,conn,1,1
end if
if keyword="" then
set rs=server.CreateObject("ADODB.RecordSet")
Sql="select id,title,user_name,submit_time,content,shenhe from content where user_name like '%"&author&"%'"&"and shenhe=1 order by submit_time desc"
rs.open sql,conn,1,1
end if
if author<>"" and keyword<>"" then
set rs=server.CreateObject("ADODB.RecordSet")
Sql="select id,title,user_name,submit_time,content,shenhe from content where user_name like '%"&author&"%'"&"and title like '%"&keyword&"%'"&" and shenhe=1 order by submit_time desc"
rs.open sql,conn,1,1
end if
%>
光明网论文发表交流中心 - 检索结果
<%
If not rs.eof then
rs.movefirst
rs.pagesize=25
rs.absolutepage=page
for i=1 to rs.pagesize
%>