boardnews.asp

来自「一个功能强大」· ASP 代码 · 共 24 行

<!--#include file=include/conn.asp -->
<!--#include file=include/config.asp -->

<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%">
<tr style="table-layout:fixed; word-break:break-all">
<%
set rs=server.CreateObject("ADODB.RecordSet") 
rs.Source="select * from board where inuse=1"
rs.Open rs.Source,conn,1,1
if rs.eof then %>
<div align="center">没有公告</div>');
<% else  
title=trim(rs("title"))
title=replace(title,"<br>","")
content=trim(rs("content"))
%>
<td width=100% align=center height=2><%=title%><br><%=rs("dateandtime")%></td></tr>
<tr><td width=100% height=2><%=rs("content")%></td></tr>
<%
end if
Rs.Close
set Rs=nothing
%>
</table>