//°Ô½Ã¹° ¸ñ·Ï °¡Á®¿À±â if(strlen($keyword) > 0) { switch ($ftype) { case "subj": $colm = title; break; case "cont": $colm = content; break; case "name": $colm = name; break; } $sql="select * from $board where code = '$code' and add_no =0 and $colm like '%$keyword%' order by main_no desc, dep_no desc"; } else $sql= "select * from $board where code = '$code' and add_no=0 order by main_no desc, dep_no desc"; $result = mysql_query($sql); $colm =""; //ÇÑȸ鿡 Ãâ·ÂÇÒ ÁÙ ¼ö $rows = $a_rows; $rows2 = 1; //ÇÑ È¸é¿¡ Ãâ·ÂÇÒ ÆäÀÌÁö ¼ö $page_scale = $a_page; // Àüü±Û ¸ñ·Ï ¼ö $count = mysql_num_rows($result); // ÇöÀç º¸¿©ÁÖ´Â ÆäÀÌÁö¹øÈ£ if (empty($page)) $page = 1; // ÇöÀç ÆäÀÌÁö¿¡ µû¸¥ º¸¿©ÁÙ °Ô½Ã¹°ÀÇ Ã¹ À§Ä¡ $start=($page-1)*$rows2; // °á°ú Áß¿¡¼ ÇöÀç ÆäÀÌÁöÀÇ Ã¹¹øÂ° ·¹ÄÚµå¼ÂÀ¸·Î À̵¿ÇÑ´Ù. if ($start > 1) mysql_data_seek($result,$start); // ÃÑ ÆäÀÌÁö¼ö $total = ceil(($count)/$rows2); ?>
$line = 0; while($row = mysql_fetch_array($result)) { //¹øÈ£ $no = $count-$start-$line; //°Ô½Ã¸ñ·Ï Ãâ·Â include("./view.html"); //Ãâ·ÂµÈ °Ô½Ã¹°ÀÇ ¼ö¿Í ÇÑȸ鿡 º¸¿©ÁÙ ÁÙ¼ö¿Í ºñ±³ if(++$line==$rows2) break; } ?> |