<!--#include file="conn.asp" -->
<%
sqlstr="select * from news,newstype where news.typeid=newstype.typeid"
set rs=conn.execute(sqlstr)
%>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
<% do while not rs.eof %>
<tr>
<td height="25"><%= rs("id") %></td>
<td><%= rs("title") %></td>
<td><%= rs("hit") %></td>
<td><%= rs("fdate") %></td>
<td><%= rs("typename") %></td>
<td><a href="update.asp?id=<%=rs("id")%>">修改</a></td>
<td>删除</td>
</tr>
<%
rs.movenext
loop
%>
</table>