方案一
复制代码代码如下:<! - #includefile =“ conn.asp” - >
<%
Owen1 =请求(“ Owen1”)
owen2 =请求(“欧文2”)
%>
<tablewidth =“ 95%” border =“ 0” cellpadding =“ 0” cellspacing =“ 0”>
<%
page = clng(请求(“ page”))
setrs = server.createobject(“ adodb.recordset”)
IFOWEN1 <>“” Andowen2 <>“”然后
sql =“ select*fromNewswhereBigClassName ='”&Owen1&“'andSmallClassName ='”&Owen2&“''orderbyiddesc”
Rs.Opensql,Conn,1,1
然后
sql =“ select*frofnewswheybigClassName ='”&Owen1&“'orderbyiddesc”
Rs.Opensql,Conn,1,1
Endif
ifrs.eofandrs.bofthen
wress.write(“暂时没有记录”)
别的
%>
<%
rs.pagesize = 15
ifpage = 0 thenpage = 1
页面= rs.pagecount
ifpage> pagesthenpage =页
rs.absolutepage = page
forj = 1tors.pagesize
if(j-1)mod3 = 0thenresponse.write(“ <tr>”)
%>
<tdheight =“ 24” align =“ center”>
<divalign =“ center”> <imgsrc =“ uppic/<%= rs(“ firstImageName”)%>“ width =“ 130” height =“ 100” border =“ 0”/> <ahref =“ onews.asp?
<%= rs(“ title”)%> </a> </div> </td>
<%
ifjmod3 = 0thenresponse.write(“ </tr>”)
Rs.Movenext
ifrs.eofthenexitfor
下一个
%>
<%
Endif
Rs.Close
setrs =没有
%>
</table>
方案二、
复制代码代码如下:<! - #includefile =“ conn.asp” - >
<%
Owen1 =请求(“ Owen1”)
owen2 =请求(“欧文2”)
%>
<tablewidth =“ 95%” border =“ 0” cellpadding =“ 0” cellspacing =“ 0”>
<%
page = clng(请求(“ page”))
setrs = server.createobject(“ adodb.recordset”)
IFOWEN1 <>“” Andowen2 <>“”然后
sql =“ select*fromNewswhereBigClassName ='”&Owen1&“'andSmallClassName ='”&Owen2&“''orderbyiddesc”
Rs.Opensql,Conn,1,1
然后
sql =“ select*frofnewswheybigClassName ='”&Owen1&“'orderbyiddesc”
Rs.Opensql,Conn,1,1
Endif
ifrs.eofandrs.bofthen
wress.write(“暂时没有记录”)
别的
%>
<%
rs.pagesize = 15