loupanvip.asp

一个专业的房地产门户网站

<!--#include file="conn.asp" -->
<%
sql="select top 4 * from loupan where okyes='yes' order by datt desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="140" border="0" cellspacing="0" cellpadding="0">
  <tr>
  <%do while not rs.eof%>
    <td> 
	<TABLE border=0 cellPadding=2 cellSpacing=2 width="140">
  <TBODY>
    <TR> 
      <TD align=middle> <IMG border=0 height=77 src="upload/<%=rs("img")%>" width=130></TD>
    </TR>
    <TR> 
      <TD class=title1 height=18 width=130><b> <font color="#800000"><%=rs("name")%></font></b></TD>
    </TR>
    <TR> 
      <TD class=font height=18><%= left(rs("addr"),14) %></TD>
    </TR>
  </TBODY>
</TABLE>
	</td>
	 <% rs.movenext
		   loop
		   rs.close
		   set rs=nothing
		 %>
  </tr>
</table>