<html>

<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>เวบบอร์ด วิทยาลัยเกษตรและเทคโนโลยีสตูล</title>
</head>
<body>
<a href="NewQuestion.php">หัวข้อใหม่</a>
<?php
$objConnect = mysql_connect("localhost","root","stcat&Fatah!") or die("Error Connect to Database");
$objDB = mysql_select_db("wbdatabase");
$strSQL = "SELECT * FROM webboard ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);

$Per_Page = 10;   // Per Page

$Page = $_GET["Page"];
if(!$_GET["Page"])
{
	$Page=1;
}

$Prev_Page = $Page-1;
$Next_Page = $Page+1;

$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
	$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
	$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
	$Num_Pages =($Num_Rows/$Per_Page)+1;
	$Num_Pages = (int)$Num_Pages;
}

$strSQL .=" order  by QuestionID DESC LIMIT $Page_Start , $Per_Page";
$objQuery  = mysql_query($strSQL);
?>
<table width="909" border="1">
  <tr>
    <th width="99"> <div align="center">รหัสกระทู้</div></th>
    <th width="458"> <div align="center">กระทู้</div></th>
    <th width="90"> <div align="center">ชื่อ</div></th>
    <th width="130"> <div align="center">วันที่</div></th>
    <th width="45"> <div align="center">คนดู</div></th>
    <th width="47"> <div align="center">ตอบกลับ</div></th>
  </tr>
<?php
while($objResult = mysql_fetch_array($objQuery))
{
?>
  <tr>
    <td><div align="center"><?php =$objResult["QuestionID"];?></div></td>
    <td><a href='ViewWebboard.php?QuestionID=<?=$objResult["QuestionID"];?>'><?=$objResult["Question"];?></a></td>
    <td><?=$objResult["Name"];?></td>
    <td><div align="center"><?=$objResult["CreateDate"];?></div></td>
    <td align="right"><?=$objResult["View"];?></td>
    <td align="right"><?=$objResult["Reply"];?></td>
  </tr>
<?
}
?>
</table>

<br>
ทั้งหมด <?= $Num_Rows;?> รายการ : <?=$Num_Pages;?> หน้า :
<?
if($Prev_Page)
{
	echo?>  <a href ='$_SERVER[SCRIPT_NAME]?Page=<?$Prev_Page?>'><< ย้อนกลับ</a>
<?}

for($i=1; $i<=$Num_Pages; $i++){
	if($i != $Page)
	{
		echo?> <a href='$_SERVER[SCRIPT_NAME]?Page=<?$?>'$i</a>
	<?}
	else
	{
		echo ?><b> <?$i ?></b>
	<?}
}
if($Page!=$Num_Pages)
{
	echo ?> <a href ='$_SERVER[SCRIPT_NAME]?Page=<?$Next_Page?>'>ถัดไป>></a> 
<?}
mysql_close($objConnect);
?>
</body>
</html>