Home > Knowledge > Training
 
Training
=TO_DAYS(NOW()) ) OR (TO_DAYS(".$myModule_Table."_StartDate)<=TO_DAYS(NOW()) AND ". $myModule_Table."_ExpireDate='0000-00-00 00:00:00' ) OR (TO_DAYS(".$myModule_Table."_StartDate)<=TO_DAYS(NOW()) AND TO_DAYS(".$myModule_Table."_ExpireDate)>=TO_DAYS(NOW()) )) AND ".$myModule_Table."_ModuleKey='".$SystemModuleKey."' "; $sql_product.=" AND ".$myModule_Table."_Status!='Disable'"; $Query=mysql_query($sql_product); $TotalRecordCount=mysql_num_rows($Query); # 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; $sql_product.=" ORDER BY ".$myModule_Table."_Order DESC LIMIT $RecordStart,$PageSize"; $sql_detail=$sql_product; $query_detail=mysql_query($sql_detail); $row_detail=mysql_fetch_array($query_detail); $txt_detail_id=$row_detail[0]; $query_product=mysql_query($sql_product); $RecordCount=mysql_num_rows($query_product); $index_top=0; $colcount=0; $colsize=3; if($RecordCount>=1){ ?> 3){ ?> "; $colcount=0; } $index_idphoto++; } if($colcount>0){ for($i=$colcount;$i<$colsize;$i++){ echo ' '; } echo ''; } ?>

| View 0
 
ไม่พบข้อมูล
1) { ?>
$NoOfPage) { $maxpage=$NoOfPage; } if($maxpage<5) { $maxpage=5; } if($maxpage-$minpage<=3) { $minpage=$maxpage-4; } if($NoOfPage<5) { $maxpage=$NoOfPage; } for($i=$minpage;$i<=$maxpage;$i++) { if($i == $PageShow) { $sb="bold"; } else { $sb="none"; } ?>