|
#2
yms1232009-09-27 15:42
|
<!--#include file="conn.asp"-->
<html>
<head>
<body>
<p><b><a href="say.asp">发表帖子</a></b>
<hr size="1" width="90%" >
<table width="454" border="1" align="center">
<tr>
<td width="83%" align="center">标题</td>
<td width="17%" align="center">作者</td>
</tr>
</table>
<table width="454" border="1" align="center">
<tbody><tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from bbs order by id"
rs.open sql,conn,1,1
if rs.recordcount=0 then
response.write "暂时还没有发表的帖子！"
rs.close
else
%>
<%
for i=1 to 20
%>
<td width="83%">
<a target="_blank" href="show.asp?id=<%=rs("id")%>"><%=rs("title")%></a>
</td>
<td width="17%"><%=rs("user")%></td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<%
end if
%>
</tbody>
</table>
<hr size="1" width="90%">
</body>
</head>
</html>