www.gusucode.com > 盐城分类信息网asp源码程序 > admin/picarticlelist.asp

    
<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<style type="text/css">
<!--
body {
	background-color: #E7EEF5;
	margin-top: 30px;
}
-->
</style></head>

<body>
<table width="89%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolorlight="#335078" bordercolordark="#FFFFFF" bgcolor="#C5D5E4">
<tr bgcolor="#B6EBC4">
<td width="362"  bgcolor="#C5D5E4"><div align="center">广告标题</div></td>
<td width="355"  bgcolor="#C5D5E4"><div align="center">连接地址</div></td>
<td colspan=2 bgcolor="#C5D5E4"><div align="center">操作</div></td>
</tr>
<%set rs=server.createobject("adodb.recordset")
sql="select * from tbl_picarticle order by picid desc"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write("<tr><td colspan=3>还没有文章</td></tr>")
else
do while not rs.eof
%>
<tr>
<td height="26" bgcolor="#DFE8F0"><%=rs("pictitle")%></td>

<td height="26" bgcolor="#DFE8F0"><%=rs("link")%></td>
<td width="125" bgcolor="#DFE8F0"><a href="picarticledel.asp?id=<%=rs("picid")%>" onclick="javascript:return confirm('确定要删除吗?');">删除</a></td>
</tr>
<%rs.movenext
loop
end if
rs.close
set rs=nothing%>
</table>
</body>
</html>