0) $sql_Diary.=" AND ".$myModule_Table."_CreateByID=".$uid;
$sql_Diary.=" AND ".$myModule_Table."_ModuleKey='".$SystemModuleKey."' AND ".$myModule_Table."_Status='Enable'";
/*
$sql_Diary.=" AND ((".
$myModule_Table."_StartDate='0000-00-00 00:00:00' AND ".
$myModule_Table."_ExpireDate='0000-00-00 00:00:00' ".
" ) OR ( ".
$myModule_Table."_StartDate='0000-00-00 00:00:00' AND ".
$myModule_Table."_ExpireDate >= NOW() ".
" ) OR ( ".
$myModule_Table."_StartDate<=NOW() AND ".
$myModule_Table."_ExpireDate='0000-00-00 00:00:00' ".
" ) OR ( ".
$myModule_Table."_StartDate<=NOW() AND ".
$myModule_Table."_ExpireDate>=NOW() ".
"))";
*/
if($GroupID>0){
$sql_Diary.=" AND ".$myModule_Table."_GroupID=".$GroupID;
}
$Search = trim($Search);
if($Search<>""){
$sql_Diary.=" AND (".
$myModule_Table."_ID =".intval($Search).
" OR ".
$myModule_Table."_Subject LIKE '%".$Search."%'".
" OR ".
$myModule_Table."_Title LIKE '%".$Search."%'".
" OR ".
$myModule_Table."_Tags LIKE '%".$Search."%'".
" OR ".
$myModule_Table."_HTMLCode LIKE '%".$Search."%'".
")";
}
$Query_Diary=mysql_query($sql_Diary);
$TotalRecordCount = MYSQL_NUMROWS($Query_Diary);
# Find max page size #########################
if($TotalRecordCount>$PageSize) {
$NoOfPage= ceil($TotalRecordCount/$PageSize);
} else {
$NoOfPage=1;
}
# Recover page show into range #########################
if($PageShow>$NoOfPage) { $PageShow=$NoOfPage; }
# Select only paging range #########################
$RecordStart = ($PageShow-1)*$PageSize;
if ($Order=="") $Order = "Order";
$sql_Diary.=" ORDER BY ".$myModule_Table."_".$Order." DESC LIMIT $RecordStart , $PageSize";
$Query_Diary=mysql_query($sql_Diary);
$RecordCount=MYSQL_NUMROWS($Query_Diary);
if($RecordCount>0){
$BgColor="#fbf8db";
?>
 |
|
 |
 |
 ผู้ชม (
) | .gif) แสดงความคิดเห็น (
) |
 |
|
|
1) { ?>
หน้าที่ จากทั้งหมด หน้า
1) { ?>
1) { ?><<
$NoOfPage) $endi = $NoOfPage;
?>
1) { ?>
,
>>
|
|
 |
|
จำนวนผู้เข้าชม :
|
