index_gonggao.asp

个人网站模板

<!-- #include file="char_gonggao.asp"-->
<% 
	set rs = server.createobject("adodb.recordset")
	sql="SELECT top 1 * FROM gonggao order by id desc" 
	rs.open sql,conn,1,1 
	if rs.bof and rs.eof then 
		response.write "暂无新闻" 
	else 
	do while not rs.eof   
%>
<table width="100%">
  <TR> 
    <TD><div align="center"><font style=line-height:150%><a><b><%=rs("gonggao_tit")%></b></a></font></div></TD>
  </TR>
</table>
<TABLE width="100%" border=0 align="center" cellPadding=0 cellSpacing=4>
  <TR> 
    <TD height="18"> <font style=line-height:150%> <a> <%=rs("txtcontent")%></a> 
      </font> </TD>
  </TR>
</table> 
<table width="100%">
  <TR>
    <TD><div align="center"><font style=line-height:150%><a><%=rs("time")%></a></font></div></TD>
  </TR>  
  </table> 
	<%
	rs.movenext     
	loop
	end if  
	rs.close   
%>