"; print "
"; if($_GET[AREA_ID]) { if($_GET[AREA_ID] == 100){ $AREA_VAL = 0; } else { $AREA_VAL = $_GET[AREA_ID]; } $SQL_ADD = " AND Area = '$AREA_VAL' "; } $SQL = "SELECT * FROM Message WHERE Category = 0 AND Open = 1 ".$SQL_ADD." ORDER BY No DESC"; $RST = mysql_query($SQL); $PageCount = 10; $COUNT_NUM = mysql_num_rows($RST); if($VAL_NO){ $BREAK_POINT = $PageCount; } else { $BREAK_POINT = $PageCount; } $page = $_REQUEST[page]; $max_page = ceil($COUNT_NUM / $BREAK_POINT); if($page == 0 || $page == 1) { $page=1; $point=0; } else { $point = ($page - 1) * $BREAK_POINT; } if($COUNT_NUM > 0) { @mysql_data_seek($RST, $point); } while($DATA = mysql_fetch_assoc($RST)) { if($PageCount == $i){ break; } if($DATA[Area]) { $SQL_AREA = "SELECT * FROM Area WHERE No = '$DATA[Area]' ORDER BY No ASC"; $RST_AREA = mysql_query($SQL_AREA); $DATA_AREA = mysql_fetch_assoc($RST_AREA); $AREA = $DATA_AREA[Name]." "; } if($DATA[YearsOld]){ $YEARS = $DATA[YearsOld]."："; } if($DATA[Sex]) { switch($DATA[Sex]) { case 1: $SEX = "男性"; break; case 2: $SEX = "女性"; break; } } print "\n"; $i++; } print "
\n";
if($max_page >= 2)
{
if($_REQUEST[page] >= 2)
{//前のページへ戻る
if($_REQUEST[page] ) { $page_link = ($_REQUEST[page] - 1); }
print "前へ \n";
}
//最大表示ページ設定
$_LIST = $PageCount;
$_MINI;
$_MAX;
if(($_REQUEST[page] > $_LIST))
{
$_MINI = ($_REQUEST[page] - ($_LIST / 2));
$_MAX = ($_REQUEST[page] + ($_LIST / 2));
}
else
{
$_MINI = 1;
$_MAX = $_LIST;
}
$k = $_MINI;
for($i = $_MINI; $i <= $_MAX; $i++)
{
if($k == $_REQUEST[page]) { print " $k |"; }
elseif(($k == 1) && !$_REQUEST[page]){ print " $k |"; }
elseif($k != $_REQUEST[page]) { print " $k |"; }
if($i >= $max_page){ break; }//最大ページ数でストップ
$k++;
}
if(($max_page >= 2) && ($max_page != $_REQUEST[page]))
{//次のページへ進む
if($_REQUEST[page] ) { $page_link = ($_REQUEST[page] + 1); }
elseif(!$_REQUEST[page]) { $page_link = 2; }
print " 次へ\n";
}
}
print "
\n";
?>