0 and $ftype==subj) $title = eregi_replace("($keyword)", "$keyword", $title); else $title=$title; if(strlen($keyword)>0 and $ftype==name) $sub1 = eregi_replace("($keyword)", "$keyword", $row[sub1]); else $sub1=$row[sub1]; //¸ñ·Ï±Û¿¡ ¾²·¹µå À̹ÌÁö ³Ö°í ¸µÅ©°É±â include("../../inc_file/list/titlelink.php"); //Àǰߴޱ⠰³¼ö ±¸Çϱâ include("../../inc_file/list/opinion.php"); //±×¸®µ¥ÀÌ¼Ç ±¸ÇöºÎ ½ÃÀÛ if($no%2==0) $my_color="white"; elseif($no%2==1) $my_color="$atb_color"; echo "\n"; //üũ¹Ú½º¸¦ »ç¿ëÇÒ °ÍÀΰ¡ ¸» °ÍÀΰ¡ °áÁ¤ if($check_box==a) echo "\n"; //¸®½ºÆ®¸¦ ¼±Åà Ãâ·ÂÇϱâ(d_main°ú d_depÀº view.html¿¡¼­ ³Ñ¾î¿Â °ª),±Û ¹øÈ£¿Í ¼±Åà À̹ÌÁö Ãâ·Â if($no_no==a && $row[main_no]==$d_main && $row[dep_no]==$d_dep) echo "\n"; elseif($no_no==a) echo "$no\n"; // °Å·¡ÀÏ echo "$sub1\n"; //Àû ¿ä echo "$title $count_opp\n"; if($row[sub2]=="in") {$account_in=number_format($row[int_1]);$account_out=" ";} elseif($row[sub2]=="out") {$account_in=" ";$account_out=number_format($row[int_1]);} // ÀÔ±Ý±Ý¾× echo "$account_in\n"; // Ãâ±Ý±Ý¾× echo "$account_out\n"; $total_rest=($total_in-$total_out); $total_rest=number_format($total_rest); // ÀÜ ¾× echo "$total_rest\n"; echo "\n"; return ($file_type); } // ========================================================ÇÔ¼ö µî·Ï ºÎ //ÀÔÃâ±Ý ³¯Â¥º°·Î Á¤¸®Çϱâ À§ÇØ... $db_array="sub1 desc,"; //°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â if(strlen($keyword) > 0) { switch ($ftype) { case "subj": $colm = title; break; case "cont": $colm = content; break; case "name": $colm = sub1; break; } $sql="select * from $board where code = '$code' and main_no>0 and add_no =0 and $colm like '%$keyword%' order by $db_array main_no desc, dep_no desc"; } else $sql= "select * from $board where code = '$code' and add_no=0 and main_no>0 order by $db_array 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); //±Û ³»¿ë º¸±â Æû°ú ÆäÀÌÁö À̵¿ Æû include("../../inc_file/list/form.php"); //°Ô½ÃÆÇ Á¦¸ñ°ú Ä«¿îÅ͸¦ ´ã°í ÀÖÀ½--htmlÀ̹ǷΠº»ÀÎÀÇ ±¸¹Ì¿¡ ¸Â°Ô ¼öÁ¤ °¡´É include("../../inc_file/list/titlecount.php"); ?> CELLSPACING=0 CELLPADDING=>
cellpadding=2 border=0 width=100% class=outline > height=25>  \n"; if($no_no==a) echo "\n"; ?> "; //°Ô½Ã¸ñ·Ï Ãâ·Â echo_line($no,$row_notice,0,0); //Ãâ·ÂµÈ °Ô½Ã¹°ÀÇ ¼ö¿Í ÇÑÈ­¸é¿¡ º¸¿©ÁÙ ÁÙ¼ö¿Í ºñ±³ if(++$line_notice==$count_notice) break; } $no = ""; //ÀԱݰú Ãâ±ÝÀÇ Àüü ±Ý¾×À» ±¸Çϱâ À§ÇØ.. while($row = mysql_fetch_array($result)) { if($row[sub2]==in) $total_in=$total_in+$row[int_1]; else $total_out=$total_out+$row[int_1]; } if($count>0) mysql_data_seek($result,$start); $line = 0; while($row = mysql_fetch_array($result)) { //¹øÈ£ $no = $count-$start-$line; //°Ô½Ã¸ñ·Ï Ãâ·Â echo_line($no,$row,$total_in,$total_out); if($row[sub2]==in) $total_in=$total_in-$row[int_1]; if($row[sub2]==out) $total_out=$total_out-$row[int_1]; //Ãâ·ÂµÈ °Ô½Ã¹°ÀÇ ¼ö¿Í ÇÑÈ­¸é¿¡ º¸¿©ÁÙ ÁÙ¼ö¿Í ºñ±³ if(++$line==$rows) break; } // °Ô½Ã¹°ÀÌ ¾ø´Â °æ¿ì if ($count == 0) echo "\n"; ?>
¹øÈ£°Å·¡ÀÏ Àû ¿ä ÀÔ±Ý±Ý¾× Ãâ±Ý±Ý¾× ÀÜ ¾×
ÀÔ·ÂµÈ °Ô½Ã¹°ÀÌ ¾ø½À´Ï´Ù.
";} ?>

>