方案一
复制代码代码如下:<! - #includefile = "conn.asp" - >
<%
owen1 = request( "owen1")
owen2 = request( "owen2")
%>
<TableWidth = "95%" border = "0" cellpadding = "0" cellspacing = "0">
<%
page = clng(request( "page"))
setrs = server.createObject( "adodb.recordset")
ifowen1 <> "" andowen2 <> "" then
sql = "select*fromnewswherebigclassname = '"&owen1& "' andsmallclassname = '"&owen2& "' orderbyiddesc"
rs.opensql、conn、1,1
elseifowen1 <> ""それから
sql = "select*fromnewswherebigclassname = '"&owen1& "' orderbyiddesc"
rs.opensql、conn、1,1
endif
ifrs.eofandrs.bofthen
respons.write( "暂时没有记录")
それ以外
%>
<%
rs.Pagesize = 15
ifpage = 0thenpage = 1
ページ= rs.pagecount
ifpage> pagesthenpage =ページ
rs.absolutepage =ページ
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?id = <%= rs(" id ")%>"ターゲット= "_> <br>
<%= rs( "title")%> </a> </div> </td>
<%
ifjmod3 = 0thenresponse.write( "</tr>")
rs.movenext
IFRS.EOFTHENEXITFOR
次
%>
<%
endif
rs.close
setrs =何もない
%>
</table>
方案二、
复制代码代码如下:<! - #includefile = "conn.asp" - >
<%
owen1 = request( "owen1")
owen2 = request( "owen2")
%>
<TableWidth = "95%" border = "0" cellpadding = "0" cellspacing = "0">
<%
page = clng(request( "page"))
setrs = server.createObject( "adodb.recordset")
ifowen1 <> "" andowen2 <> "" then
sql = "select*fromnewswherebigclassname = '"&owen1& "' andsmallclassname = '"&owen2& "' orderbyiddesc"
rs.opensql、conn、1,1
elseifowen1 <> ""それから
sql = "select*fromnewswherebigclassname = '"&owen1& "' orderbyiddesc"
rs.opensql、conn、1,1
endif
ifrs.eofandrs.bofthen
respons.write( "暂时没有记录")
それ以外
%>
<%
rs.Pagesize = 15