$chk_date = substr(date("Y-m-d H:i:s"),-19,-9);
if (empty($page)){
$page=1;
}
mysql_connect($host,$user,$passwd);
mysql_query("SET NAMES utf8");
if($category==""){
$sql_data = "select no from $group_data";
}
else{
$sql_data = "select no from $group_data where category='$category'";
}
$result_data = mysql_db_query($dbname,$sql_data);
$NRow = mysql_num_rows($result_data);
$rt = $NRow%$list_page;
if($rt!=0) {
$totalpage = floor($NRow/$list_page)+1;
}
else {
$totalpage = floor($NRow/$list_page);
}
$goto = ($page-1)*$list_page;
if($category==""){
$sql_data = "select * from $group_data order by no DESC limit $goto,$list_page";
}
else{
$sql_data = "select * from $group_data where category='$category' order by no DESC limit $goto,$list_page";
}
include("category.php");
?>
$chk_date = substr(date("Y-m-d H:i:s"),-19,-9);
$result = mysql_db_query($dbname,$sql_data) or die("Faied SQL Query");
while ($row_data = mysql_fetch_array($result)) {
$bgc = ($bgc==$rowColor1) ? $rowColor2 : $rowColor1;
include("variable.php");
$ck_date = trim(substr($row_data["date_data"],-19,-9));
$ck_reply_date = trim(substr($row_data["reply_date"],-19,-9));
echo "";
echo "";
if(($ck_reply_date==$chk_date)&&($ck_date==$chk_date)){
echo "
$title โดยคุณ : $name_data
มีผู้ตอบแล้ว[ $reply ]
 | ";
}
elseif($ck_reply_date==$chk_date){
echo "
$title โดยคุณ : $name_data
มีผู้ตอบแล้ว[ $reply ]  | ";
}
elseif($ck_date==$chk_date){
echo "
$title โดยคุณ : $name_data
มีผู้ตอบแล้ว[ $reply ]  | ";
}
else{
echo "
$title โดยคุณ : $name_data
มีผู้ตอบแล้ว[ $reply ] | ";
}
echo " ";
echo " ";
}
?>
// table แสดงเลขหน้า
echo "";
echo "| ";
echo "";
// สร้าง link เพื่อไปหน้าก่อน-หน้าถัดไป
if($page>1 && $page<=$totalpage) {
$prevpage = $page-1;
echo "[หน้าก่อน = $prevpage]";
}
echo " กำลังแสดงหน้าที่ $page/$totalpage ";
if($page!=$totalpage) {
$nextpage = $page+1;
echo "[หน้าถัดไป = $nextpage]";
}
echo "";
echo " | ";
echo "| ";
// วนลูปแสดงเลขหน้าทั้งหมด
for($i=1 ; $i<$page ; $i++) {
echo "$i ";
}
echo "$page ";
for($i=$page+1 ; $i<=$totalpage ; $i++) {
echo "$i ";
}
echo " | ";
echo" ";
?>
|