10) {
$startBlockPage = floor(($startPage - 1) / 10) * 10 + 1;
$prevBlockPage = $startBlockPage - 1;
$nextBlockPage = $startBlockPage + 10;
} else {
$startBlockPage = 1;
}
$PageLinks = null;
$PageLinks = "
";
if($countTotalPage > 10) $PageLinks .= "- 맨앞
";
if($prevBlockPage > 0) {
$PageLinks .= "- 이전
";
}
for($i = 0, $j = 0; $j < $countTotalPage && $i < 10; $i ++) {
$j = $startBlockPage + $i;
if($startPage == $j) {
$PageLinks .= "- ".$j."
";
} else {
$PageLinks .= "- ".$j."
- ";
}
}
if($nextBlockPage > 10 && $nextBlockPage < $countTotalPage) {
$PageLinks .= "
- 다음
";
}
if($countTotalPage > 10) $PageLinks .= "- 맨끝
";
$PageLinks .= "
";
// 쿼리 시작
$Products["idx"] = NULL;
$Products["order_seq"] = NULL;
$Products["name"] = NULL;
$Products["hidden"] = NULL;
$Products["photo_title1"] = NULL;
$Products["photo_title2"] = NULL;
$Products["photo_title3"] = NULL;
$Products["photo_title4"] = NULL;
$Products["photo_title5"] = NULL;
$Products["status1"] = NULL;
$Products["status2"] = NULL;
$Products["status3"] = NULL;
$Products["status4"] = NULL;
$Products["con_text"] = NULL;
$Products["memo"] = NULL;
$Products["hyun_addr"] = NULL;
$Products["scale"] = NULL;
$Products["surface"] = NULL;
$Products["households"] = NULL;
$Products["sale_date"] = NULL;
$Products["into_date"] = NULL;
$Products["percent"] = NULL;
$Query = " SELECT " . selectQuery($Products, "con");
$Query .= " FROM con";
$Query .= " where 1";
$Query .= " and hidden = 'no'";
$Query .= " and status4 = 'y'";
$Query .= " and con_group = 1";
$Query .= " order by order_seq asc";
$Query .= " LIMIT $startNo, $ViewPerPage";
//echo $Query ;
$cnn = sql_query($Query);
while($rst = sql_fetch_array($cnn)) {
$Records[] = $rst;
}
include "./_header.php";
?>
주택분야
for($i=0; $i
-
$bg_img = (file_exists("./admin/con_files/".$Records[$i]["idx"]."/image1_large.jpg"))?"/admin/con_files/".$Records[$i]["idx"]."/image1_large.jpg":"";
?>
=$Records[$i]["name"]?>
공정률 : =$Records[$i]["percent"]?>%
%">
- 위치=$Records[$i]["hyun_addr"]?>
- 세대수=$Records[$i]["households"]?>
- 규모=$Records[$i]["scale"]?>
- 입주예정=$Records[$i]["into_date"]?>
}?>