newleft.asp

本房地产网站功能强大

<div align="center">
	<TABLE cellPadding=0 width="255" 
border=1 style="border-collapse: collapse" bordercolor="#99CCFF">
              <TBODY>
              <TR>
                <TD background="../img1/fj.jpg" height="42">&nbsp; <b>
				<font color="#EE5806">市场动态</font></b></TD></TR>
              <TR>
                <TD>
				<table width="255" border="0" cellpadding="0" cellspacing="0" class="main">
                    <tr valign="top"> 
                      <td align="center" width="255"> 
						<table width="255" border="0" cellpadding="0" cellspacing="0"  class="main">
                          <%
					set rs=server.CreateObject("adodb.recordset")
					sql="select top 6 * from news where sort=2  order by dnt desc"
					rs.open sql,conn,1,1
					do while not rs.eof
					%>
                          <tr class="black"> 
                            <td width="10">　</td>
                            <td width="12" height="19"> <div align="center">
								<img border="0" src="../img/arr_w1.gif" width="9" height="9"></div></td>
                            <td width="178" height="19"><a href=jiaju_detail.asp?newsid=<%=trim(rs("newsid"))%>&amp;sort=2>
							<font color="#EE5806"><%=left(trim(rs("topic")),12)%></font></a></td>
                          </tr>
                          <%
					rs.movenext
					loop
					rs.close
					set rs=nothing
					%>
                        </table></td>
                    </tr>
                    <tr> 
                      <td align="center">
						<p align="right">
						<a href="jiaju_more.asp?sort=2"><font color="#EE5806">更多</font></a>&nbsp;&nbsp;&nbsp; </td>
                    </tr>
                  </table>
				</TD></TR>
              <TR>
                <TD background="../img1/fj.jpg" height="39">&nbsp; <b> 
				<font color="#EE5806">土地市场</font></b></TD></TR>
              <TR>
                <TD>
				<table width="255" border="0" cellpadding="0" cellspacing="0" class="main">
                    <tr class="black" height="7"> 
                      <td height="7" colspan="3"></td>
                    </tr>
                    <%
					set rs=server.CreateObject("adodb.recordset")
					sql="select top 6 * from news where sort=3  order by dnt desc"
					rs.open sql,conn,1,1
					do while not rs.eof
					%>
                    <tr class="black"> 
                      <td width="10">　</td>
                      <td width="12" height="19"> <div align="center">
						<img border="0" src="../img/arr_w1.gif" width="9" height="9"></div></td>
                      <td height="19"><a href=jiaju_detail.asp?newsid=<%=trim(rs("newsid"))%>&amp;sort=3>
						<font color="#EE5806"><%=left(trim(rs("topic")),12)%></font></a></td>
                    </tr>
                    <%
					rs.movenext
					loop
					rs.close
					set rs=nothing
					%>
                  </table>
				</TD></TR>
              <TR>
                <TD height="17">
				<p align="right"><a href="jiaju_more.asp?sort=3"><font color="#EE5806">更多</font></a>&nbsp;&nbsp;&nbsp; </TD></TR>
              <TR>
                <TD background="../img1/fj.jpg" height="37">&nbsp; <b>
				<font color="#EE5806">新盘动态</font></b></TD></TR>
              <TR>
                <TD>
				<table width="255" border="0" cellpadding="0" cellspacing="0" class="main">
                    <tr class="black" height="7"> 
                      <td height="7" colspan="2"></td>
                    </tr>
                    <%
                    set rs=server.CreateObject("adodb.recordset")

					sql="select top 7 * from news where sort=5  order by dnt desc"
					rs.open sql,conn,1,1
					do while not rs.eof
					%>
                    <tr class="black"> 
                      <td width="19" height="19"> <div align="center">
						<img border="0" src="../img/arr_w1.gif" width="9" height="9"></div></td>
                      <td width="313" height="19"><a href=jiaju_detail.asp?newsid=<%=trim(rs("newsid"))%>&amp;sort=5>
						<font color="#EE5806"><%=left(trim(rs("topic")),15)%></font></a></td>
                    </tr>
                    <%
					rs.movenext
					loop
					rs.close
					%>
                  </table>
				</TD></TR>
              <TR>
                <TD>
				<p align="right"><a href="jiaju_more.asp?sort=5"><font color="#EE5806">更多</font></a>&nbsp;&nbsp;&nbsp; </TD></TR>
              <TR>
                <TD>　</TD></TR>
              </TBODY></TABLE></div>