<!--#include file="conn.asp"-->
<!--#include file="adovbs.inc"-->
<title>簡單留言本</title>
<b>簡單留言本</b>
<%
set rs = conn.execute("exec sp_ebook 'select'")
if rs.eof and rs.bof then
response.write "暫時(shí)沒有記錄"&"<a href='add.asp'>"&"請?zhí)砑佑涗?quot;&"</a>"
else
%>
<% do while not rs.eof %>
<table  align="center" border="1" bordercolor="#999999" width="400" cellpadding="0"  cellspacing="0" class="size1">
  <tr>
<td width="20%" class="size2">
作者：<%=rs("uname")%>
</td>
<td  colspan="2" width="70%">
標(biāo)題：<%=rs("utitle")%>
</td>
</tr>
<tr>
<td>&nbsp;

</td>
<td width="100%" height="100" colspan="2">
內(nèi)容:<%=rs("ubody")%>
</td>
</tr>
<tr class="size2">
<td colspan="3" align="right">
發(fā)表時(shí)間為:<%
response.write rs("utime")

if session ("admin") <>"" then
%>
<a href="del.asp?id=<%=rs("id")%>">刪除</a>
&nbsp;&nbsp;
<%end if%>
 <a href="add.asp">添加</a></td>

</tr>
</table>

<br>

<%
rs.movenext
loop
rs.close
set rs=nothing
conn.close
end if
%>