0 order by add_no desc, name, add_no desc"; $result = mysql_query($sql); $t_count=0; while($ro = mysql_fetch_array($result)) { $t_count=$t_count+$ro[int_1]; } //¸ñ·Ï±ÛÀÇ ±æÀÌ ÀÚ¸£±â. include("../../inc_file/list/cut.php"); //°Ë»ö¾î¿¡ ¹ÙÅÁ»ö ÀÔÈ÷±â if(strlen($keyword)>0 and $ftype==subj) $title = eregi_replace("($keyword)", "$keyword", $title); else $title=$title; if(strlen($keyword)>0 and $ftype==sub1) $sub1 = eregi_replace("($keyword)", "$keyword", $row[sub1]); else $sub1=$row[sub1]; //¸ñ·Ï±Û¿¡ ¸µÅ©°É±â if(($read_key==c and strlen($id)>0) or $read_key==a or $read_key==b) $title = "$title\n"; else $title="$title\n"; //Àǰߴޱ⠰³¼ö ±¸Çϱâ //include("../../inc_file/list/opinion.php"); //ÇÑ ÁÙ ±ß±â echo "\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); ?>
> ´ëȸÀϽÃ\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ?>
´ë ȸ ¸í Á¾ ¸ñÁ¢¼öÀÏÁ¢¼ö
»óÅÂ
½Åû
Àοø
5 10 H F R1 R2

>