Shulou(Shulou.com)06/01 Report--

/ / get search results

$sql = "SELECT * FROM `br_esf_village_ price`p, (SELECT villageId,MAX (updateTime) max_time FROM br_esf_village_price GROUP BY villageId) as bpublication WHERE p.villageId = b.villageId AND p.updateTime=b.max_time AND v.villageId = p.villageId"

If ($condition ['qy']) {/ / region

$sql. = "and fangAreaId =". $condition ['qy']. "

}

If ($condition ['qy']) {/ / Business area

$sql. = "and fangTradingId =". $condition ['sq']. "

}

If ($condition ['jg'] | | $condition [' zdyjg']) {/ / Price

$temp = array ()

$temp = $condition ['zdyjg']? Explode (",", $condition ['zdyjg']): explode (",", $condition [' jg'])

If (count ($temp) = = 2) {

$sql. = "and p.price > =". $temp [0]. "and p.price =". $temp [0]. ""

}

}

If ($condition ['dt'] = =' Y') {/ / Metro

$sql. = "and hasMetro = 1"

}

If ($order=='default') {

$sql. = "ORDER BY orderBy desc"

}

If ($order=='pricedesc') {

$sql. = "ORDER BY p.price desc"

}

If ($order=='priceasc') {

$sql. = "ORDER BY p.price asc"

}

$sql. = "limit $PageClass- > firstRow,$PageClass- > listRows"

$data=$this- > query ($sql)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.