newsinfo.asp

php 语言写的c2c商城网站程序

<table width="100%" align="center" border="0" cellspacing="0" cellpadding="0" height="22">
<%'dim i
		  i=0
		  set rs=server.CreateObject("adodb.recordset")
		  rs.open "select top 7 newsname,adddate,newsid from shop_news order by adddate desc",conn,1,1
		  if rs.eof and rs.bof then
		  response.write "目前还没有新闻！"
		  else
		  do while not rs.eof
		  i=i+1%>
<tr> 
<td width="10%" height="24" align="center">☉</td>
<td width="90%" height="24">
<%if len(trim(rs("newsname")))>12 then
		  response.write "<a href=""javascript:;"" onClick=""javascript:window.open('news.asp?id="&rs("newsid")&"','news','width=432,height=288,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"" title="&year(rs("adddate"))&"年"&month(rs("adddate"))&"月"&day(rs("adddate"))&"日发布><font color=#FF6600>"&left(trim(rs("newsname")),12)&"...."&"</font></a><br>"
		  else
		  response.write "<a href=""javascript:;"" onClick=""javascript:window.open('news.asp?id="&rs("newsid")&"','news','width=432,height=288,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"" title="&year(rs("adddate"))&"年"&month(rs("adddate"))&"月"&day(rs("adddate"))&"日发布><font color=#FF6600>"&trim(rs("newsname"))&"</font></a><br>"
		  end if
		  if i>=10 then exit do%>
</td>
</tr>
<%rs.movenext
		  loop
		  end if
		  rs.close
		  set rs=nothing%>
</table>