|
|
<%
set rs=server.createobject("adodb.recordset")
sqlstr="SELECT *,(house.id) as house_id,(chengQu.id) as chengQu_id,(house_type.id) as house_type_id FROM "&_
"(house INNER JOIN chengQu ON house.chengQu = chengQu.id) "&_
"INNER JOIN house_type ON house.house_type = house_type.ID "&_
"where house.id="&request("id")
rs.open sqlstr,conn,1,3
%>
<%
rs.close
set rs=nothing
%>
|
|
|
|
