/*
division
1:Áß¿ä¼½Ä
2:QNA
3:ÇкÎ
4:´ëÇпø
5:°øÁö»çÇ×
6:´º½º
7:Ãë¾÷Á¤º¸
8:Á߿伽ĸðÀ½
*/
include "./include/_prepend.php";
cacheControl(0);
$db = getConnection();
if(!$page) { $page = 1; }
#°Ô½Ã¹° ÃÑ °³¼ö
$query = "SELECT COUNT(no) AS cnt FROM ysboard where division=5 or division=6";
$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 = 5;
########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ##########
$query = "SELECT * FROM ysboard where division=5 order by tid DESC, todr ASC LIMIT " . $num_per_page;
/* ÃßÈÄ Mysql ¹öÀüÀ» ¾÷µ¥ÀÌÆ® Çҽà ÀÌ ¹®À¸·Î ´ëü °¡´É
$query = "SELECT * FROM ysboard where division=6 order by tid DESC, todr ASC LIMIT 1 UNION SELECT * FROM ysboard where division=5 order by tid DESC, todr ASC LIMIT " . ($num_per_page-1) ; */
$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;
}
}
$query1 = "SELECT COUNT(idx) AS cnt FROM research";
$rs1 = @mysql_query($query1, $db);
if(!$rs1) {
jserror('ÀڷḦ ÀÐÀ» ¼ö ¾ø½À´Ï´Ù.'. mysql_error());
}
$result1 = mysql_fetch_array($rs1);
$total_record1 = $result1[cnt];
if($total_record1==0) {
// jserror('°Ë»öµÈ °á°ú°¡ ¾ø½À´Ï´Ù.','location.replace("board_list.php?page=1")');
}
########## ÇöÀçÀÇ ÆäÀÌÁö¿¡¼ Ãâ·ÂÇÒ °Ô½Ã¹°ÀÇ ¹üÀ§¸¦ °áÁ¤ÇÑ´Ù. ##########
$num_per_page1 = 6;
########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ##########
$query1 = "SELECT * FROM research order by idx DESC LIMIT " . $num_per_page1;
$result1 = mysql_query($query1);
if (!$result1) {
echo mysql_error($db) . '
';
exit;
}
if(!$total_record1) {
$first1 = 1;
$last1 = 0;
} else {
$first1 = $num_per_page1*($page-1);
$last1 = $num_per_page1*$page;
$IsNext1 = $total_record1 - $last1;
if($IsNext1 > 0) {
$last1 -= 1;
} else {
$last1 = $total_record1 - 1;
}
}
$queryr = "SELECT COUNT(no) AS cnt FROM ysboard where division=5 or division=6";
$rsr = @mysql_query($queryr, $db);
if(!$rsr) {
jserror('ÀڷḦ ÀÐÀ» ¼ö ¾ø½À´Ï´Ù.'. mysql_error());
}
$resultr = mysql_fetch_array($rsr);
$total_recordr = $resultr[cnt];
if($total_recordr==0) {
// jserror('°Ë»öµÈ °á°ú°¡ ¾ø½À´Ï´Ù.','location.replace("board_list.php?page=1")');
}
########## ÇöÀçÀÇ ÆäÀÌÁö¿¡¼ Ãâ·ÂÇÒ °Ô½Ã¹°ÀÇ ¹üÀ§¸¦ °áÁ¤ÇÑ´Ù. ##########
$num_per_pager = 3;
########## ÇöÀçÆäÀÌÁöÀÇ ¹üÀ§³»¿¡ Ãâ·ÂÇÒ °á°ú·¹Äڵ弼Ʈ¸¦ ¾ò´Â´Ù. ##########
$queryr = "SELECT * FROM ysboard where division=6 order by tid DESC, todr ASC LIMIT " . $num_per_pager;
$resultr = mysql_query($queryr);
if (!$resultr) {
echo mysql_error($db) . '
';
exit;
}
if(!$total_recordr) {
$firstr = 1;
$lastr = 0;
} else {
$firstr = $num_per_pager*($page-1);
$lastr = $num_per_pager*$page;
$IsNextr = $total_recordr - $lastr;
if($IsNextr > 0) {
$lastr -= 1;
} else {
$lastr = $total_recordr - 1;
}
}
?>
|
|||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||