📄 loupanlist.asp
字号:
<!--#include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=name%></title>
<link href="css/css.css" rel="stylesheet" type="text/css">
</head>
<body background="images/topbj.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<!--#include file="top.asp" -->
</td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" class="bk">
<tr>
<td width="180" align="center" valign="top" background="images/index_00.gif">
<!--#include file="left.asp" -->
</td>
<td valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="40" bgcolor="#ffb600"><img src="images/20080320134845251.gif" width="32" height="19"></td>
<td width="534" bgcolor="#ffb600"><table width="98%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="83%"><font color="#FFFFFF">最新楼盘推荐</font></td>
<td width="17%" align="right"><font color="#FFFFFF"> </font></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#ffb600">
<td colspan="2"><img src="images/5x5.gif" width="5" height="5"></td>
</tr>
<tr> </tr>
</table></td>
</tr>
<tr>
<td align="center" valign="top"><table width="96%" border="0" cellspacing="0" cellpadding="0">
<tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from loupan order by datt desc"
rs.open sql,conn,1,1
rs.pagesize=5
filename="loupanlist.asp"
%>
<%if not (rs.eof and rs.bof) then
Page = cint(Request.querystring("Page"))
If Page < 1 Then Page = 1
If Page > rs.PageCount Then Page = rs.PageCount
showpages rs,Page
%>
<%else%>
<tr>
<td colspan=5><center>
<font color=red>没有信息</font> </center></td>
</tr>
<%end if%>
<%Sub showpages( rs,Page )
rs.AbsolutePage = Page
for i=0 to rs.pagesize-1
%>
<td> <TABLE width="100%" border=0 cellPadding=8 cellSpacing=2 >
<TBODY>
<TR>
<TD colspan="2" bgcolor="#f1f1f1" > <b><font color="#cc0033"><%=rs("name")%></font></b>
</TD>
</TR>
<TR>
<TD width="140" height=80 align="center"><img src="upload/<%=rs("img")%>" width=130 height=77 border="1"></TD>
<TD width="72%" valign="top" class="16h"><font color="#cc0033"><strong>楼盘介绍：</strong></font><a href="loupanshow.asp?id=<%=rs("id")%>" target="_blank"><%= left(rs("content"),100) %>
<% If len(rs("content"))>100 Then %>
......
<% End If %>
</a></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
<%
rs.movenext
If rs.EOF Then Exit For
Next%>
<%End Sub%>
<tr>
<td height="20" align="center" bgcolor="#f1f1f1">
<%
response.write "共<font color=red>"&rs.recordcount&"</font>条信息 "
response.write rs.pagesize&"条一页 "
if Page=1 then
response.write"[首页] "
end if
If Page <> 1 Then
Response.Write "<A HREF="&filename&"?keyword="&keyword&"&Page=1>[首页]</A>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -