include "../menu.php"; ?> |
|
$sni="select * from news_index where id=1";
$reni=mysql_query($sni) or die("ERROR $sni บรททัด 89");
$rni=mysql_fetch_row($reni);
echo $rni[1];
?> |
|
$scate="SELECT * FROM `webboard_category` ORDER BY id ASC";
$recate=mysql_query($scate) or die("Error $scate");
while($rcate=mysql_fetch_row($recate)){
$url=rewrite($rcate[1]);
?>
|
$strCATE="SELECT * FROM `board` WHERE cate_id='$rcate[0]' ";
$QueryCATE=mysql_query($strCATE) or die("ERROR $strCATE บรรทัด 221");
$NumCATE = mysql_num_rows($QueryCATE);
echo $NumCATE;
?>
กระทู้ |
} ?>
|
|
|
|
 |
หัวข้อปักหมุด |
 |
กระทู้ยังไม่ได้ถูกตอบ |
 |
กระทู้ที่ถูกตอบ |
 |
ผู้ตั้งกระทู้ |
|
 |
|
|
หัวข้อ |
เมื่อ |
อ่าน |
ตอบ |
$swb="SELECT id, title, date, view, name, upd_date, status, cate_id FROM `board` WHERE sticky='1' ORDER BY upd_date DESC";
$rewb=mysql_query($swb) or die("ERROR $swb");
while($rwb=mysql_fetch_row($rewb)){
$url=rewrite($rwb[1]);
?>
 |
$today=date("Y-n-j H:i:s");
$yesterday=date("Y-m-d H:i:s",strtotime("- 1 day"));
//echo $objResult[5];
if($rwb[5]>=$yesterday){
//echo "yes";
if($rwb[6]==1){
?>
}else if($rwb[6]==2){
?>
}
}else{
//echo "no";
}
?>
|
|
 |
$strWB="SELECT name, date FROM `ans_board` WHERE topic_id='$rwb[0]' ORDER BY id DESC ";
$WBQuery=mysql_query($strWB) or die("ERROR บรรทัด 437");
$WBResult=mysql_fetch_row($WBQuery);
$NumWB = mysql_num_rows($WBQuery);
?>
ตอบล่าสุดโดย
if($NumWB<=0){ echo "ยังไม่มีผู้ตอบ"; }else{ echo $WBResult[0];?>
เมื่อ
$replyDate = $WBResult[1];
echo DateTime($replyDate);
}
?>
|
|
|
$postDate = $rwb[2];
echo DateTime($postDate);
?>
|
|
|
} ?>
$strSQL="SELECT id, title, date, view, name, upd_date, status, cate_id FROM `board` WHERE sticky='0' ";
$objQuery=mysql_query($strSQL) or die("ERROR บรรทัด 344");
$Num_Rows = mysql_num_rows($objQuery);
$Per_Page = 20; // 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 upd_date DESC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL) or die("ERROR");
while($objResult = mysql_fetch_row($objQuery))
{
$url=rewrite($objResult[1]);
?>
$strWB2="SELECT name, date FROM `ans_board` WHERE topic_id='$objResult[0]' ORDER BY id DESC ";
$WBQuery2=mysql_query($strWB2) or die("ERROR $strWB2 บรรทัด 531");
$WBResult2=mysql_fetch_row($WBQuery2);
$NumWB2=mysql_num_rows($WBQuery2);
if($NumWB2<=0){
?>
}else{ ?>
} ?> |
$today=date("Y-n-j H:i:s");
$yesterday=date("Y-m-d H:i:s",strtotime("- 1 day"));
//echo $objResult[5];
if($objResult[5]>=$yesterday){
//echo "yes";
if($objResult[6]==1){
?>
}else if($objResult[6]==2){
?>
}
}else{
//echo "no";
}
?>
|
|
 |
ตอบล่าสุดโดย
if($NumWB2<=0){ echo "ยังไม่มีผู้ตอบ"; }else{ echo $WBResult2[0];?>
เมื่อ
$replyDate = $WBResult2[1];
echo DateTime($replyDate);
}
?>
|
|
|
$postDate = $objResult[2];
echo DateTime($postDate);
?>
|
|
|
} ?>
$pages = new Paginator;
$pages->items_total = $Num_Rows;
$pages->mid_range = 10;
$pages->current_page = $Page;
$pages->default_ipp = $Per_Page;
$pages->url_next = $_SERVER["PHP_SELF"]."?QueryString=value&Page=";
$pages->paginate();
echo $pages->display_pages()
?> |
|
|
|
|