about.asp

庐江二中

javastr="<table width=\"100%\" border=\"0\">"
<!--#include file="articleconn.asp"-->
<%about=request("about")
title=request("title")
if about<>""  then
sql="select top 5 * from article where about like '%" & about & "%' and title not like '%" & title & "%' order by dateandtime desc"
set rs=conn.execute(sql)%>
<%
dim i
do while not rs.eof
%>
javastr=javastr+"<tr><td>"
javastr=javastr+"<font color=\"#000000\" size=\"2\">- </font><span style=\"font-size:9pt;line-height: 15pt\"><a href=\"list.asp?id=<%=rs("newsid")%>\") ><%=rs("title")%></span></a>"
javastr=javastr+"</td></tr>"
<%i=i+1
if i=5 then exit do
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing %>
javastr=javastr+"</table>"
document.write (javastr)
<%else%>
document.write ("没有相关文章")
<%end if%>