NEWS & EVENTS
-
rowCount();
//echo $cnt;
$num = $total_record - ($pagesize * ($var_Page -1));
if ($cnt > 0) {
for ($i = 0; $i < $cnt; $i++) {
$row = $result->fetch(PDO::FETCH_ASSOC);
//내용 변경
//$print_content = strip_tags($row["CONTENT"]);
//대표이미지 추출
$var_SQL = " SELECT";
$var_SQL .= " FILE_SEQ";
$var_SQL .= ", FILE_PATH";
$var_SQL .= ", FILE_NAME";
$var_SQL .= ", FILE_SAVE";
$var_SQL .= ", FILE_DESC";
$var_SQL .= ", DOWN_COUNT";
$var_SQL .= ", REG_DATE";
$var_SQL .= " FROM TB_BOARD_NOTICE_FILE";
$var_SQL .= " WHERE BOARD_SEQ=:BOARD_SEQ";
$var_SQL .= " AND FILE_TYPE='attach_one'";
$var_SQL .= " ORDER BY FILE_NO DESC";
$var_SQL .= " Limit 1";
$stmt = $pdo->prepare($var_SQL);
$stmt->bindParam(":BOARD_SEQ", $row["BOARD_SEQ"]);
$stmt->execute();
$totalc = $stmt->rowCount();
if ($totalc > 0) {
for ($x = 0; $x < $totalc; $x++) {
$rs = $stmt->fetch(PDO::FETCH_ASSOC);
$col_file_seq = trim($rs["FILE_SEQ"]);
$col_file_path = trim($rs["FILE_PATH"]);
$col_file_name = trim($rs["FILE_NAME"]);
$col_file_save = trim($rs["FILE_SAVE"]);
$col_file_desc = trim($rs["FILE_DESC"]);
$col_file_down_cnt = trim($rs["DOWN_COUNT"]);
$col_file_regdate = trim($rs["REG_DATE"]);
$print_one_image = "
-
closeCursor();
?>
";
}
?>
-
frontpaging($var_Page, $tt_page, $list);
?>
