<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
conn.open constr
sql1="select top 12 * from mc where (typeid='1' and title like'%公寓%') or (typeid='1' and title like'%房地产%') order by id desc"
sql2="select top 12 * from mc where typeid='2'order by id desc"
set rs1=server.CreateObject("adodb.recordset")
set rs2=server.CreateObject("adodb.recordset")
rs1.open sql1,conn,1,1
rs2.open sql2,conn,1,1
%>
北京公寓网-北京公寓信息网-中国房地产行业网群
