\n";
//´ëȸÀϽà Ãâ·Â
echo "$sub1 ($row[sub2]) | \n";
//´ëȸ¸í Ãâ·Â
echo "$title | \n";
//Á¾¸ñ Ãâ·Â
if($row[int_1]==0) $km_5="¡¿"; else $km_5="¡Û";
if($row[int_2]==0) $km_10="¡¿"; else $km_10="¡Û";
if($row[int_3]==0) $km_half="¡¿"; else $km_half="¡Û";
if($row[int_4]==0) $km_full="¡¿"; else $km_full="¡Û";
if($row[int_5]==0) $gita_1="¡¿"; else $gita_1="¡Û";
if($row[int_6]==0) $gita_2="¡¿"; else $gita_2="¡Û";
echo "$km_5 | \n";
echo "$km_10 | \n";
echo "$km_half | \n";
echo "$km_full | \n";
echo "$gita_1 | \n";
echo "$gita_2 | \n";
//Á¢¼öÀÏ Ãâ·Â
echo "($row[sub4])~($row[sub5]) | \n";
//Á¢¼ö»óÅÂ Ãâ·Â
if($row[sub5]>=$run_date) $en_date="Á¢¼öÁß"; else $en_date="¸¶°¨";
echo "$en_date | \n";
//½ÅûÀοø Ãâ·Â
echo "$t_count | \n";
echo "
\n";
return ($file_type);
}
// ========================================================ÇÔ¼ö µî·Ï ºÎ
//°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â
if(strlen($keyword) > 0)
{
switch ($ftype) {
case "subj":
$colm = title;
break;
case "cont":
$colm = content;
break;
case "sub1":
$colm = sub1;
break;
}
$sql="select * from $board
where code = '$code' and main_no>0 and
add_no =0 and
$colm like '%$keyword%'
order by sub1 desc, main_no desc, dep_no desc";
}
else
$sql= "select * from $board
where code = '$code' and add_no=0 and main_no>0
order by sub1 desc, main_no desc, dep_no desc";
//¾Æ·¡ sql¹®Àº °øÁö±ÛÀ» ¼±Åà Ãâ·ÂÇϱâ À§ÇØ ÀÛ¼ºÇÑ °ÍÀÌ´Ù.
$sql_notice= "select * from $board
where code = '$code' and add_no=0 and main_no<0
order by main_no desc, dep_no desc";
$result_notice = mysql_query($sql_notice);
$result = mysql_query($sql);
$colm ="";
//ÇÑȸ鿡 Ãâ·ÂÇÒ ÁÙ ¼ö
$rows = $a_rows;
//ÇÑ È¸é¿¡ Ãâ·ÂÇÒ ÆäÀÌÁö ¼ö
$page_scale = $a_page;
// Àüü±Û ¸ñ·Ï ¼ö
$count = mysql_num_rows($result);
// ÇöÀç º¸¿©ÁÖ´Â ÆäÀÌÁö¹øÈ£
if (empty($page)) $page = 1;
// ÇöÀç ÆäÀÌÁö¿¡ µû¸¥ º¸¿©ÁÙ °Ô½Ã¹°ÀÇ Ã¹ À§Ä¡
$start=($page-1)*$rows;
// °á°ú Áß¿¡¼ ÇöÀç ÆäÀÌÁöÀÇ Ã¹¹øÂ° ·¹ÄÚµå¼ÂÀ¸·Î À̵¿ÇÑ´Ù.
if ($start > 1) mysql_data_seek($result,$start);
// ÃÑ ÆäÀÌÁö¼ö
$total = ceil(($count)/$rows);
?>