?> </div> <div class="syss_fcone">MSL:<?php echo $house->ml_num; ?> </div> <div class="syss_fctwo"><a href="<?php echo Yii::app()->createUrl('house/view', array('id' => $house->id)); ?> " target="_blank"><?php echo $house->name; ?> </a></div> <div class="syss_fcthree"> <?php $imglist = explode(',', get_tn_image($county, $ml_num)); foreach ($imglist as $value) { ?> <div class="syss_fcthree_pic"><img src="<?php echo Yii::app()->request->baseUrl; ?> /<?php echo $value; ?> " width="92" height="73" /></div> <?php } ?> <div class="cl"></div> </div> <div class="syss_fcfour">
<!--豪宅推荐开始--> <div class="grtz"> <div class="grtz_title"><span>豪宅推荐</span></div> <div class="grtz_con"> <ul> <?php //$sqlhaozi = "select * from h_house where lp_dol>3000000 and recommend=1 limit 0,3"; $sqlhaozi = "select h.*,m.municipality_cname as cname from h_house h,h_mname m where h.municipality=m.municipality AND \r\nh.lp_dol>3000000 and h.yr_built = '6-15' AND\r\nh.area in ('Toronto','Peel','York','Halton') AND\r\nh.bath_tot > 3 order by h.pix_updt desc limit 0,3"; $resultshazai = $db->createCommand($sqlhaozi)->query(); foreach ($resultshazai as $househaizai) { ?> <li> <dl> <dt> <?php $imglist1 = get_tn_image($househaizai["county"], $househaizai["ml_num"]); $pic1 = explode(",", $imglist1)[0]; ?> <a href="<?php echo Yii::app()->createUrl('house/view', array('id' => $househaizai["id"])); ?> " target="_blank"><img src="<?php echo Yii::app()->request->baseUrl; ?> /<?php echo $pic1; ?> " width="120" height="72"/></a> </dt> <dd class="bt"><?php