index.asp

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

                    <select name="txtfangx" class="form">
                      <option value="%" selected>--不限--</option>
                      <option value="高层">高层</option>
                      <option value="小高层">小高层</option>
                      <option value="多层">多层</option>
                      <option value="别墅">别墅</option>
                      <option value="写字楼">写字楼</option>
                      <option value="商住综合">商住综合</option>
                      <option value="门面房">门面房</option>
                      <option value="厂房仓库">厂房仓库</option>
                      <option value="平房">平房</option>
                    </select>
                    </span><span class=9size><span style="font-size: 9pt" id="fps0"> 
                    </span> </span></td>
                </tr>
                <tr> 
                  <td height="26" valign="bottom"><span class=9size> <span style="font-size: 9pt"> 
                    </span><span style="font-size: 9pt" id="fps0">&nbsp;&nbsp; 
                    区域: </span> </span> <span style="font-size: 9pt" id="fps0"> 
                    <select name="select4" size="1" class=f11>
                      <option selected value="%">--不限--</option>
                      <%dim rs2,sql2,sel
                          set rs2=server.createobject("adodb.recordset")
                          sql2="select * from fctype"
                          rs2.open sql2,conn,1,1                   
                     
                     do while not rs2.eof
        if typeID=cstr(rs2("typeID")) then
               sel="selected"
        else
               sel=""
        	
        response.write "<option " & sel & " value='" +  Cstr(rs2("type")) + "'>" + rs2("type") + "</option>"
       rs2.movenext
   end if   
 loop
rs2.close
%>
                    </select>
                    </span><span class=9size> <span style="font-size: 9pt"> </span> 
                    </span></td>
                </tr>
                <tr> 
                  <td height="26" valign="bottom"><span class=9size> <span style="font-size: 9pt"> 
                    </span><span style="font-size: 9pt" id="fps0">&nbsp;&nbsp; 
                    面积: </span><span class=9size><span style="font-size: 9pt" id="fps4"> 
                    </span><span class=9size><span style="font-size: 9pt" id="fps0">
                    <select name=txtMianj class=form>
                      <option value=% selected>---不 限---</option>
                      <option value=A>50平方以下</option>
                      <option value=B>50-70平方</option>
                      <option value=C>70-90平方</option>
                      <option value=D>90-110平方</option>
                      <option value=E>110-150平方</option>
                      <option value=F>150平方以上</option>
                    </select>
                    </span></span><span style="font-size: 9pt"> </span></span><span style="font-size: 9pt"> 
                    </span> </span></td>
                </tr>
                <tr> 
                  <td height="26" valign="bottom"><span class=9size> <span style="font-size: 9pt"> 
                    </span><span style="font-size: 9pt" id="fps0">&nbsp;&nbsp; 
                    总价: </span><span style="font-size: 9pt" id="fps5"> </span><span class=9size><span style="font-size: 9pt" id="fps1">
                    <select name=txtJiag class=form>
                      <option value=% selected>---不 限---</option>
                      <option value=A>8万以下</option>
                      <option value=B>8-10万</option>
                      <option value=C>10-12万</option>
                      <option value=D>12-15万</option>
                      <option value=E>15-20万</option>
                      <option value=F>20-25万</option>
                      <option value=G>25-30万</option>
                      <option value=H>30-40万</option>
                      <option value=I>40-50万</option>
                      <option value=J>50-100万</option>
                      <option value=K>100-200万</option>
                      <option value=L>200万以上</option>
                    </select>
                    </span></span><span style="font-size: 9pt"> </span><span style="font-size: 9pt"> 
                    </span> </span></td>
                </tr>
                <tr> 
                  <td height="26" valign="bottom"> <span class=9size><span style="font-size: 9pt"> 
                    </span><span style="font-size: 9pt" id="fps0">&nbsp;&nbsp; 
                    时间: </span><span class=9size><span style="font-size: 9pt" id="fps6"> 
                    </span><span class=9size><span style="font-size: 9pt" id="fps2">
                    <select name=txtsj class=form>
                      <option value=3600 selected>---不 限---</option>
                      <option value=7>七天内信息</option>
                      <option value=15>半月内信息</option>
                      <option value=30>一月内信息</option>
                      <option value=90>三月内信息</option>
                    </select>
                    </span></span><span style="font-size: 9pt"> </span></span><span style="font-size: 9pt"> 
                    </span> </span> </td>
                </tr>
                <tr> 
                  <td height="28" align="center" valign="bottom">　　　　　　　 
                    <input name="imageField3" type="image" src="images/sou.gif" width="43" height="19" border="0"> 
                  </td>
                </tr>
                <tr class="bk"> 
                  <td align="center" valign="top" background="images/index_00.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> </tr>
                      <tr> 
                        <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr> 
                              <td width="40" bgcolor="#2986d6"><img src="images/biao1.gif" width="40" height="25"></td>
                              <td width="135" bgcolor="#2986d6"><table border="0" cellspacing="0" cellpadding="0">
                                  <tr> 
                                    <td><font color="#FFFFFF">中介公司</font></td>
                                  </tr>
                                </table></td>
                              <td width="1" rowspan="3"></td>
                            </tr>
                            <tr> 
                              <td colspan="2" bgcolor="#005194"><img src="images/5x5.gif" width="5" height="5"></td>
                            </tr>
                            <tr> </tr>
                          </table></td>
                      </tr>
                      <tr> 
                        <td align="center" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="5">
                            <tr> 
                              <td align="center" valign="top"><table width="95%" border="0" cellpadding="2" cellspacing="1">
                                  <% 
					    set rs=server.createobject("adodb.recordset")
						sql="select top 5 * from zhiye where typeid='中介公司' and okyes='yes' order by datt DESC"
                        rs.open sql,conn,1,1
						if rs.eof and rs.bof then
						Response.Write"<br>暂无信息"
						end if
					%>
                                  <%do while not rs.eof%>
                                  <tr> 
                                    <td background="images/lib.gif"><p><img src="images/index_03.gif" width="14" height="13"> 
                                        <%if len(rs("ming"))>8 then%>
                                        <a href="zhiyeshow.asp?id=<%=rs("id")%>" target="_blank"><%=left(rs("ming"),8)%>...</a> 
                                        <%else%>
                                        <a href="zhiyeshow.asp?id=<%=rs("id")%>" target="_blank"> 
                                        <%=rs("ming")%></a> 
                                        <%end if%>
                                      </p></td>
                                  </tr>
                                  <% rs.movenext
											loop
											rs.close
											set rs=nothing
		                                     %>
                                </table></td>
                            </tr>
                            <tr> 
                              <td align="right" valign="top"><a href="zhongjielist.asp">更多&gt;&gt;</a> 
                              </td>
                            </tr>
                            <tr> 
                            </tr>
                          </table></td>
                      </tr>
                    </table></td>
                </tr>
                <tr class="bk"> 
                  <td align="center" valign="top" background="images/index_00.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> </tr>
                      <tr> 
                        <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr> 
                              <td width="40" bgcolor="#2986d6"><img src="images/biao1.gif" width="40" height="25"></td>
                              <td width="135" bgcolor="#2986d6"><table border="0" cellspacing="0" cellpadding="0">
                                  <tr> 
                                    <td><font color="#FFFFFF">开发公司</font></td>
                                  </tr>
                                </table></td>
                              <td width="1" rowspan="3"></td>
                            </tr>
                            <tr> 
                              <td colspan="2" bgcolor="#005194"><img src="images/5x5.gif" width="5" height="5"></td>
                            </tr>
                            <tr> </tr>
                          </table></td>
                      </tr>
                      <tr> 
                        <td align="center" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="5">
                            <tr> 
                              <td align="center" valign="top"><table width="95%" border="0" cellpadding="2" cellspacing="1">
                                  <% 
					    set rs=server.createobject("adodb.recordset")
						sql="select top 5 * from zhiye where typeid='房产开发' and okyes='yes' order by datt DESC"
                        rs.open sql,conn,1,1
						if rs.eof and rs.bof then
						Response.Write"<br>暂无信息"
						end if
					%>
                                  <%do while not rs.eof%>
                                  <tr> 
                                    <td background="images/lib.gif"><p><img src="images/index_03.gif" width="14" height="13"> 
                                        <%if len(rs("ming"))>8 then%>
                                        <a href="zhiyeshow.asp?id=<%=rs("id")%>" target="_blank"><%=left(rs("ming"),8)%>...</a> 
                                        <%else%>
                                        <a href="zhiyeshow.asp?id=<%=rs("id")%>" target="_blank"> 
                                        <%=rs("ming")%></a> 
                                        <%end if%>
                                      </p></td>
                                  </tr>
                                  <% rs.movenext
											loop
											rs.close
											set rs=nothing
		                                     %>
                                </table></td>
                            </tr>
                            <tr> 
                              <td align="right" valign="top"><a href="zhiyelist.asp">更多&gt;&gt;</a> 
                              </td>
                            </tr>
                          </table></td>
                      </tr>
                    </table></td>
                </tr>
                <tr class="bk"> 
                  <td align="center" valign="top" background="images/index_00.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> </tr>
                      <tr> 
                        <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr> 
                              <td width="40" bgcolor="#2986d6"><img src="images/biao1.gif" width="40" height="25"></td>
                              <td width="135" bgcolor="#2986d6"><table border="0" cellspacing="0" cellpadding="0">
                                  <tr> 
                                    <td><font color="#FFFFFF">建材装潢</font></td>
                                  </tr>
                                </table></td>
                              <td width="1" rowspan="3"></td>
                            </tr>
                            <tr> 
                              <td colspan="2" bgcolor="#005194"><img src="images/5x5.gif" width="5" height="5"></td>
                            </tr>
                            <tr> </tr>
                          </table></td>
                      </tr>
                      <tr> 
                        <td align="center" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="5">
                            <tr> 
                              <td align="center" valign="top"><table width="95%" border="0" cellpadding="2" cellspacing="1">
                                  <% 
					    set rs=server.createobject("adodb.recordset")
						sql="select top 5 * from zhiye where typeid='建材装潢' and okyes='yes' order by id DESC"
                        rs.open sql,conn,1,1
						if rs.eof and rs.bof then
						Response.Write"<br>暂无信息"
						end if
					%>
                                  <%do while not rs.eof%>
                                  <tr> 
                                    <td background="images/lib.gif"><p><img src="images/index_03.gif" width="14" height="13"> 
                                        <%if len(rs("ming"))>8 then%>
                                        <a href="zhiyeshow.asp?id=<%=rs("id")%>" target="_blank"><%=left(rs("ming"),8)%>...</a> 
                                        <%else%>
                                        <a href="zhiyeshow.asp?id=<%=rs("id")%>" target="_blank"> 
                                        <%=rs("ming")%></a> 
                                        <%end if%>
                                      </p></td>
                                  </tr>
                                  <% rs.movenext
											loop