方案一
複製代碼代碼如下:<! - #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