=3 && $month<=8) $now_session_no=1; else $now_session_no=2; if ($course_year=="") $course_year=$now_course_year; if ($session_no<1 || $session_no>2 || $session_no=="") $session_no=$now_session_no; ########## if ($division<=0 || $division>5) { $division = 1; } $query = "SELECT COUNT(idx) AS cnt FROM course WHERE course_year=$course_year AND session like '%$session_no%' AND division like '%$division%'"; $rs = @mysql_query($query, $db); if(!$rs) { jserror('ÀڷḦ ÀÐÀ» ¼ö ¾ø½À´Ï´Ù.'. mysql_error()); } $result = mysql_fetch_array($rs); $total_record = $result[cnt]; if($total_record==0) { // jserror('°Ë»öµÈ °á°ú°¡ ¾ø½À´Ï´Ù.','location.replace("board_list.php?page=1")'); } ########## ÇöÀçÀÇ ÆäÀÌÁö¿¡¼­ Ãâ·ÂÇÒ °Ô½Ã¹°ÀÇ ¹üÀ§¸¦ °áÁ¤ÇÑ´Ù. ########## $num_per_page = 1000; $end_limit=$num_per_page * $page; $start_limit=$end_limit - $num_per_page; ########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ########## $query = "SELECT * FROM course WHERE course_year=$course_year AND session like '%$session_no%' AND division like '%$division%'"; //echo $query; $result = mysql_query($query); if (!$result) { echo mysql_error($db) . '
'; exit; } if(!$total_record) { $first = 1; $last = 0; } else { $first = $num_per_page*($page-1); $last = $num_per_page*$page; $IsNext = $total_record - $last; if($IsNext > 0) { $last -= 1; } else { $last = $total_record - 1; } } ########## Àüü ÆäÀÌÁö¼ö ########## $total_page = ceil($total_record/$num_per_page); ########## °Ô½Ã¹° ¸ñ·Ï ÇÏ´ÜÀÇ °¢ ÆäÀÌÁö·Î Á÷Á¢ À̵¿ÇÒ ¼ö ÀÖ´Â ÆäÀÌÁö¸µÅ©¿¡ ´ëÇÑ ¼³Á¤ ########## $page_per_block = 10; # ÇÏ´Ü¿¡ ³ª¿Ã ÆäÀÌÁö °³¼ö $total_block = ceil($total_page/$page_per_block); $block = ceil($page/$page_per_block); $first_page = ($block-1)*$page_per_block; $last_page = $block*$page_per_block; if($total_block <= $block) { $last_page = $total_page; } ?>
³âµµ
.gif" width="70" height="40"> .gif" width="70" height="40"> .gif" width="70" height="40"> .gif" width="70" height="40"> .gif" width="90" height="40">
$last) break; $idx = mysql_result($result,$i,0); $course_year = mysql_result($result,$i,1); $session_no = mysql_result($result,$i,2); $division = mysql_result($result,$i,3); $course_name = mysql_result($result,$i,4); $class = mysql_result($result,$i,5); $class_no = mysql_result($result,$i,6); $subject = mysql_result($result,$i,7); $teacher = mysql_result($result,$i,8); $content = mysql_result($result,$i,9); $regdate = mysql_result($result,$i,10); ?> ""){?> = $last) { break; } else { $first++; } } ?>
°³¿ä : ¼ö
¼öÁ¤ »èÁ¦
µî·Ï "") {?> logout   modify login   join