rank3.asp

1、下载亿博购物系统 亿博购物系统每次发布最新版本

<%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 9 bookid,bookname,liulancount from shop_books order by liulancount desc",conn,1,1%> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" > 
<tr> <td valign="top" ><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> 
<tr> <td align="center"> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> 
<tr> <td align="center"> <%set rs=server.CreateObject("adodb.recordset")
		rs.open "select Top 9 * from shop_books where newsbook=1 order by bookid desc",conn,1,1
		if rs.eof and rs.bof then
		response.write "<center><br><font color=red size=2>对不起，暂无新品！</font></font>"
		'response.End
		else
		%> <table cellspacing=0 cellpadding=0 border=0 width="100%" ALIGN="CENTER"> 
<%
		dim i_1,i_count
		i_1=int((rs.recordcount+1)/3)
		if i_1>8 then 
		i_1=8
		end if
		'response.write i_1
		for i_count=1 to i_1%> <tr> <td width="34%" valign=top><TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0"> 
<TR> <TD WIDTH="34%"><TABLE WIDTH="95%" HEIGHT="120" BORDER="0" CELLPADDING=0 CELLSPACING=0 ALIGN="CENTER" > 
<TR> <TD WIDTH="100%" HEIGHT="99" ALIGN="center" VALIGN="TOP"><TABLE HEIGHT=99 CELLSPACING=0 CELLPADDING=0 WIDTH=99 BORDER=0 ALIGN="center"> 
<TBODY> <TR> <TD BACKGROUND=images/xt_bj.gif ALIGN=center VALIGN="MIDDLE"> <%if rs("bookpic")="" then 
response.write "<div align=center><a href=list.asp?id="&rs("bookid")&" target=_blank><img src=images/emptybook.gif width=75 height=75 border=0></a></div>"
else%> <A HREF=list.asp?id=<%=rs("bookid")%> TARGET=_blank><IMG SRC="<%=trim(rs("bookpic"))%>"  WIDTH=75 BORDER=0 HEIGHT="75"></A> 
<%end if%> </TD></TR> </TBODY> </TABLE></TD></TR><TR><TD WIDTH="100%" HEIGHT="35" ALIGN="center" VALIGN="MIDDLE" BGCOLOR="#F7FFEF"><FONT COLOR="#999999"><%response.write "<a class=a4 href=list.asp?id="&rs("bookid")&" target=_blank><font color=#FF6600>"
				if len(trim(rs("bookname")))>22 then
				response.write left(trim(rs("bookname")),20)&"..."
				else
				response.write trim(rs("bookname"))
				end if
				response.write "</font></a>"
				%></FONT></TD></TR><TR><TD WIDTH="100%" ALIGN="CENTER"center"><DIV ALIGN="CENTER"><FONT COLOR="#FF0000">￥</FONT><S><%=formatnumber(rs("shichangjia"),0)%></S> 
<FONT COLOR="#FF0000">-&gt;</FONT> <FONT COLOR=#FF6600><%=formatnumber(rs("huiyuanjia"),0)&"元"%></FONT></DIV></TD></TR> 
</TABLE><%rs.movenext%></TD></TR> </TABLE></td><td width="33%" valign="top" > 
<%if rs.eof then%> <%else%> <table width="100%" border="0" cellspacing="0" cellpadding="0"> 
<tr> <td><table width="95%" height="120" cellpadding=0 cellspacing=0  ALIGN="CENTER"> 
<td width="100%" align="center" HEIGHT="99" VALIGN="TOP"><TABLE HEIGHT=99 CELLSPACING=0 CELLPADDING=0 WIDTH=99 BORDER=0 ALIGN="center"> 
<TBODY> <TR> <TD BACKGROUND=images/xt_bj.gif ALIGN=center VALIGN="MIDDLE"> <%if rs("bookpic")="" then 
response.write "<div align=center><a href=list.asp?id="&rs("bookid")&" target=_blank><img src=images/emptybook.gif width=75 height=75 border=0></a></div>"
else%> <A HREF=list.asp?id=<%=rs("bookid")%> TARGET=_blank><IMG SRC="<%=trim(rs("bookpic"))%>"  WIDTH=75 BORDER=0 HEIGHT="75"></A> 
<%end if%> </TD></TR> </TBODY> </TABLE></td></tr><TR><td width="100%" align="center" HEIGHT="35" VALIGN="MIDDLE" BGCOLOR="#F7FFEF"><FONT COLOR="#999999"><%response.write "<a class=a4 href=list.asp?id="&rs("bookid")&" target=_blank><font color=#FF6600>"
				if len(trim(rs("bookname")))>22 then
				response.write left(trim(rs("bookname")),20)&"..."
				else
				response.write trim(rs("bookname"))
				end if
				response.write "</font></a>"
				%></FONT></td></tr><TR><td width="100%" align="center"><FONT COLOR="#FF0000">￥</FONT><S><%=formatnumber(rs("shichangjia"),0)%></S> 
<FONT COLOR="#FF0000">-&gt;</FONT> <FONT COLOR=#FF6600><%=formatnumber(rs("huiyuanjia"),0)&"元"%></FONT></td></tr> 
</table></td></tr> </table><%rs.movenext%> <%end if%> </td><td width="33%" valign="top" ><%if rs.eof then%> 
<%else%> <TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0"> <TR> 
<TD><TABLE WIDTH="95%" HEIGHT="120" CELLPADDING=0 CELLSPACING=0  ALIGN="CENTER"> 
<TD WIDTH="100%" ALIGN="center" HEIGHT="99" VALIGN="TOP"><TABLE HEIGHT=99 CELLSPACING=0 CELLPADDING=0 WIDTH=99 BORDER=0 ALIGN="center"> 
<TBODY> <TR> <TD BACKGROUND=images/xt_bj.gif ALIGN=center VALIGN="MIDDLE"> <%if rs("bookpic")="" then 
response.write "<div align=center><a href=list.asp?id="&rs("bookid")&" target=_blank><img src=images/emptybook.gif width=75 height=75 border=0></a></div>"
else%> <A HREF=list.asp?id=<%=rs("bookid")%> TARGET=_blank><IMG SRC="<%=trim(rs("bookpic"))%>"  WIDTH=75 BORDER=0 HEIGHT="75"></A> 
<%end if%> </TD></TR> </TBODY> </TABLE></TD></TR><TR><TD WIDTH="100%" ALIGN="center" HEIGHT="35" VALIGN="MIDDLE" BGCOLOR="#F7FFEF"><FONT COLOR="#999999"><%response.write "<a class=a4 href=list.asp?id="&rs("bookid")&" target=_blank><font color=#FF6600>"
				if len(trim(rs("bookname")))>22 then
				response.write left(trim(rs("bookname")),20)&"..."
				else
				response.write trim(rs("bookname"))
				end if
				response.write "</font></a>"
				%></FONT></TD></TR><TR><TD WIDTH="100%" ALIGN="center"><FONT COLOR="#FF0000">￥</FONT><S><%=formatnumber(rs("shichangjia"),0)%></S> 
<FONT COLOR="#FF0000">-&gt;</FONT> <FONT COLOR=#FF6600><%=formatnumber(rs("huiyuanjia"),0)&"元"%></FONT></TD></TR> 
</TABLE></TD></TR> </TABLE><%rs.movenext%> <%end if%> </td></tr> <%next%> <%
rs.close
set rs=nothing%> </table><%end if%> </td></tr> </table></td></tr> </table></td></tr> 
</table>