www.gusucode.com > 芝麻屋小小留言本 2.0码程序 > admin/ly_lb2.asp

    <!--#include file="conn.asp" -->
<%
if not session("check")=1 then 
response.Redirect"left.asp"
else
end if
%>
<%
exec="select * from guestbook order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
 
<link href="icon/alink.css" rel="stylesheet" type="text/css">
<table width="99%" border="0" align="center" cellpadding="1" cellspacing="1" class="bx">
  <tr>
    <td height="25" colspan="7" bgcolor="#FFFFFF" class="bg">留言列表</td>
  </tr>
  <% if not rs.eof then %>  
  <tr>
    <td height="18" colspan="7" bgcolor="#FFFFFF">　
      <!--#include file="pg.asp" --></td>
  </tr>
<% for i=1 to rs.pagesize %>	 
<% if rs.eof then
   exit for
   end if
%> 
  <tr>
    <td height="1" colspan="7" align="center" class="bg4"></td>
  </tr>
  <tr>
    <td width="21" align="center" valign="top" bgcolor="#FFFFFF" class="bghui"><%=rs("id")%></td>
    <td width="112" height="22" bgcolor="#FFFFFF" class="bghui">姓名：<%=rs("ly_name")%> 　　</td>
    <td width="141" bgcolor="#FFFFFF" class="bghui">性别：<%=rs("ly_sex")%> </td>
    <td width="147" valign="baseline" bgcolor="#FFFFFF" class="bghui"><table width="146" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="20"><img src="icon/T3.GIF" width="9" height="17"></td>
        <td width="84"><%=rs("ly_tel")%></td>
      </tr>
    </table></td>
    <td width="112" bgcolor="#FFFFFF" class="bghui"><table width="105" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="26"><img src="icon/Q2.GIF" width="16" height="16"></td>
          <td width="79" valign="bottom"><a href="http://wpa.qq.com/msgrd?V=1&Uin=<%=rs("ly_qq")%>&Site=联系我&Menu=yes"target=blank ><%=rs("ly_qq")%></a></td>
        </tr>
    </table></td>
    <td width="168" valign="bottom" bgcolor="#FFFFFF" class="bghui"><table width="130" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="24"><img src="icon/E5.GIF" width="14" height="10"></td>
          <td width="106"><%=rs("ly_email")%></td>
        </tr>
    </table></td>
    <td width="28" align="center" bgcolor="#FFFFFF" class="bghui"><a href="LY_DEL.ASP?id=<%=rs("id")%>" onclick='{if(confirm(&quot;确定删除?　&quot;)){return true;}return false;}'><img src="icon/D.GIF" width="16" height="16" border="0"></a></td>
  </tr>
  <tr bgcolor="#FFFFFF">
    <td width="21" rowspan="2" align="center" valign="top" bgcolor="#FFFFFF" class="wenliang">&nbsp;</td>    
	<td colspan="4">标题：<span class="wenliang"><%=rs("ly_bt")%> </span>　　　　　 　　　　　</td>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="13%">&nbsp;</td>
          <td width="87%"><%=rs("ly_time")%></td>
        </tr>
      </table></td>
    <td><a href="ly_hf.asp?id=<% =rs("id") %>">回复</a></td>
  </tr>
  <tr bgcolor="#FFFFFF">
    <td colspan="4"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="7%">内容：</td>
          <td width="93%"><%=rs("ly_nr")%></td>
        </tr>
        <tr>
          <td>回复：</td>
          <td><%=rs("ly_hf")%></td>
        </tr>
      </table></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>

<%
rs.movenext
next
%>  
<% else %>
  <tr class="bg" >
    <td height="21" colspan="7" align="center" valign="top" bgcolor="#FFFFFF">- 暂时没有留言记录 -</td>
  </tr>
<% end if %>
</table>