<?php session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://w...content-available-to-author-only...3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://w...content-available-to-author-only...3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>無標題文件</title>
</head>
<body>
<?php

$username=$_SESSION[name];
$current_page=$_POST[current_page];

$current_board;
$i=0;
$total=0;
$last_page;
$last_k;
$last_j;
$page;

$link = mysql_pconnect("localhost", "root", "1234") or die("無法與MySQL建立連線"); 
$select=mysql_select_db("cake") or die("無法選擇cake資料庫");
$myquery = "select current_board from member where username='$username'";
$current_board_result = mysql_query($myquery) or die("查詢 Query 錯誤");
mysql_query("SET NAMES 'utf8'");
while($current_board_row = mysql_fetch_array($current_board_result)){
	$current_board=$current_board_row[current_board];
}

$myquery = "select current_page from member where username='$username'";
$last_page_result = mysql_query($myquery) or die("查詢 Query 錯誤");
mysql_query("SET NAMES 'utf8'");
while($last_page_row = mysql_fetch_array($last_page_result)){
	$last_page=$last_page_row[current_page];
}
$myquery   = "select id from article";
$count_result = mysql_query($myquery) or die("查詢 Query 錯誤");
mysql_query("SET NAMES 'utf8'");
while($count_row = mysql_fetch_array($count_result)){
	$total++;
}

if(($total%5)==0)
	$page=floor($total/5);
else
	$page=ceil($total/5);
if($current_page==1){
	$k=(5*$current_page)-5;
	$j=(5*$current_page);
	
}
else if($current_page==$page){
	$k=$total-5;
	$j=$total;
}
else if(($last_page-$current_page)>0){
	
	$myquery   = "select current_k from member where username='$username'";
	$last_k_result = mysql_query($myquery) or die("查詢 Query 錯誤");
	mysql_query("SET NAMES 'utf8'");
	while($last_k_row = mysql_fetch_array($last_k_result)){
		$last_k=$last_k_row[current_k];
	}
	
	$myquery   = "select current_j from member where username='$username'";
	$last_j_result = mysql_query($myquery) or die("查詢 Query 錯誤");
	mysql_query("SET NAMES 'utf8'");
	while($last_j_row = mysql_fetch_array($last_j_result)){
		$last_j=$last_j_row[current_j];
	}
	
	$k=$last_k-5;
	$j=$last_j-5;
	
}
else if(($last_page-$current_page)<0){

	$myquery = "select current_k from member where username='$username'";
	$last_k_result = mysql_query($myquery) or die("查詢 Query 錯誤");
	mysql_query("SET NAMES 'utf8'");
	while($last_k_row = mysql_fetch_array($last_k_result)){
		$last_k=$last_k_row[current_k];
	}
	
	$myquery = "select current_j from member where username='$username'";
	$last_j_result = mysql_query($myquery) or die("查詢 Query 錯誤");
	mysql_query("SET NAMES 'utf8'");
	while($last_j_row = mysql_fetch_array($last_j_result)){
		$last_j=$last_j_row[current_j];
	}
	$k=$last_k+5;
	$j=$last_j+5;
}

$myquery = "select id where board='$current_board' limit $k,$j ";
$id_result = mysql_query($myquery) or die("查詢 Query 錯誤");
mysql_query("SET NAMES 'utf8'");
while($id_row = mysql_fetch_array($id_result)){
	$k++;
	echo "<div onmouseover=\"change_background(".$k.")\" id=\"".$k."\" style=\"background-color:white;\">";
	echo "<div id=\"z".($i+1)."\">";
	echo $k;
	echo "&nbsp;&nbsp;";
	echo "</div>";
	echo "</div>";
	$i++;
	if($i==5)
		break;
}
?>
</body>
</html>