|
$bannercat = "estate_left";
include "$DOCUMENT_ROOT/admin/adm_clients/banner_print.inc";
?>
|
$query = "select a.idx as idx, a.estphoto as estphoto, a.addr as addr, a.city as city, a.tuja,";
$query = $query. " code1.code_name as property_name,code1.code_idx as property_idx, ";
$query = $query. " code2.code_name as selltype_name, code2.code_idx as selltype_idx, a.estphoto,";
$query = $query. " a.price as price, a.r_date as r_date, a.regi_name as regi_name";
$query = $query. " from est_prime a ";
$query = $query. " inner join codes code1 on a.property = code1.code_idx";
$query = $query. " inner join codes code2 on a.selltype = code2.code_idx";
$query = $query. " inner join member m on a.regi_id = m.user_id";
$query = $query. " and a.estphoto!='' ";
$query = $query. " order by r_date desc limit 4";
$img_h=80;
$img_w=107;
$dbconn->query($query);
$i = 0;
while($dbconn->next_record()) {
$idx[$i] = $dbconn->f("idx");
$tuja1[$i] = $dbconn->f("tuja");
$estphoto[$i] = $dbconn->f("estphoto");
$addr[$i] = $dbconn->f("addr");
$city[$i] = $dbconn->f("city");
$price[$i] = number_format($dbconn->f("price"));
$ptype[$i]= $dbconn->f("property_name");
$stype[$i]= $dbconn->f("selltype_name");
$ptype_no[$i]= $dbconn->f("property_idx");
$stype_no[$i]= $dbconn->f("selltype_idx");
if($stype_no[$i]!="391"){
$price[$i]="ÀÓ´ë";
}
$r_name[$i] = $dbconn->f("regi_name");
$r_date[$i]=date("m-d-y",$dbconn->f("r_date"));
$photo[$i] = $dbconn->f("estphoto");
$img[$i] = $photo[$i];
if($photo[$i]){
$photo[$i]="$DOCUMENT_ROOT/estate/coimg/".$photo[$i];
$imgsize[$i]=GetImageSize($photo[$i]);
$imgh[$i] = $imgsize[$i][1];
$imgw[$i] = $imgsize[$i][0];
if($imgsize[$i][1] > $imgsize[$i][0]){ //********************************* ¼¼·ÎÅ
if($imgsize[$i][1] > $img_h){
$ratio[$i]=$img_h/$imgsize[$i][1];
$imgsize[$i][1] = $img_h;
$imgsize[$i][0] = $imgsize[$i][0]*$ratio[$i];
}
}else{
if($imgsize[$i][0] > $img_w){
$ratio[$i]=$img_w/$imgsize[$i][0];
$imgsize[$i][0] = $img_w;
$imgsize[$i][1] = $imgsize[$i][1]*$ratio[$i];
}
}
}
$i++;
}
$i_num = $i;
?>
}else{?>
}?>
|
|
´Þ·¯ |
|
|
|
}else{?>
ÇöÀçµî·ÏµÈ »çÁø¸Å¹°ÀÌ
¾ø½À´Ï´Ù
}?>
|
|
|
|
}?>
Fatal error: Call to a member function query() on a non-object in /home/iolo72/public_html/estate/est_main_l.inc on line 21
| |