会编程语言求助
<td width="507" bgcolor="#C0DCB1"><span class="style6">最新开的店铺</span></td>
<td width="61" bgcolor="#C0DCB1"><a href="shop/show_room_more.asp" target="_blank">>>更多...</a></td>
<td width="10" bgcolor="#C0DCB1"> </td>
</tr>
</table></td>
</tr>
<%
set rs_star=server.CreateObject("adodb.recordset")
sql="select top 2 * from room"
rs_star.open sql,conn,1,1
%>
<tr>
<td bgcolor="#C0DCB1"><div align="center">
<table width="588" height="140" border="0" cellpadding="0" cellspacing="1">
<% row=1 %>
<tr bgcolor="#F5FBEA">
<%
for ipage=1 to rs_star.pagesize
if rs_star.eof then exit for%>
<td width="132" bgcolor="#F5FBEA"><div align="center"><a href="images/BEDROOM_010.gif" target="_blank"><img src="shop/<%=rs_star("room_img")%>" width="120" height="80" border="0"></a></div></td>
<td width="154"><div align="left">店铺名称：<%=rs_star("room_name")%><br>
掌柜：<%=rs_star("username")%><br>
顾客：<%=rs_star("friend")%><br>
<br>
<input type="submit" name="Submit" value="参观店铺" onClick="window.location='shop/room_show.asp?username=<%=rs_star("username")%>'">
</div></td>
<%if row mod 2<>0 then%>
<%end if%>
<% if row mod 2 =0 then%>
</tr>
<tr>
<%end if%>
<%rs_star.MoveNext
row=row+1
next
rs_star.close
set rs_star=nothing
%>
</table>
把店铺按照最新开的顺序显示,我需要在什么地方加什么代码啊?
