'Disable' AND ".$myModule_TableGroup."_Language='Thai' AND ".$myModule_TableGroup."_ModuleKey='product' AND ".$myModule_TableGroup."_ID='".$_GET['txt_submenu_new']."' ORDER BY ".$myModule_TableGroup."_Order DESC limit 0,1 "; $query_group = mysql_query($sql_group); $row_group = mysql_fetch_array($query_group); $txt_submenu_subject =rechangeQuot($row_group[0]); ?> Home > Products  ".$txt_menu_subject."";} ?>
 
=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'"; if($_GET['txt_menu']>=1){ $sql_product.="AND ".$myModule_Table."_GID='".$_GET['txt_menu']."' "; } if($_GET['searchKey']!=""){ $sql_product.=" AND ( ". $myModule_Table."_Subject LIKE '%".$_GET['searchKey']."%' OR ". $myModule_Table."_Title LIKE '%".$_GET['searchKey']."%' ) "; } $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); if($_GET['contant_id']>=1){ $txt_contant_id=$_GET['contant_id']; }else{ $txt_contant_id=$row_detail[0]; } $query_product=mysql_query($sql_product); $RecordCount=mysql_num_rows($query_product); $index_top=0; if($RecordCount>=1){ while($row_product=mysql_fetch_array($query_product)){ $txt_product_id=$row_product[0]; $txt_product_subject=rechangeQuot($row_product[1]); $txt_product_pic=$myModule_Path_GalleryThumbnail_Fornt."/".$row_product[2]; $txt_product_Title=nl2br(rechangeQuot($row_product[3])); ?>
 
ไม่พบข้อมูล
 
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"; } ?>
 
=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."_ID='".$txt_contant_id."'"; $sql_product.=" ORDER BY ".$myModule_Table."_Order DESC LIMIT 0,1"; $query_product=mysql_query($sql_product); $count_product=mysql_num_rows($query_product); $row_product=mysql_fetch_array($query_product); $txt_product_id=$row_product[0]; $txt_product_subject=rechangeQuot($row_product[1]); $txt_product_txtpic=$row_product[2]; $txt_product_pic=$myModule_Path_GalleryThumbnail_Fornt."/".$row_product[2]; $txt_product_txthtml=$row_product[3]; $txt_product_html=$myModule_Path_HTMLFiles_Fornt."/".$row_product[3]; $txt_product_price=number_format($row_product[4]); ?>
=1){?>Price : Baht
=1){ while($row_file=mysql_fetch_array($query_file)){ $downloadID=$row_file[0]; $downloadFile = $row_file[2]; $imageType = strstr($downloadFile,'.'); $linkRelativePath = "upload/".$SystemModuleKey."/FileUpload/".$row_file[2]; $downloadName=$row_file[3]; if($downloadName==""){ $downloadName = "click here to Download"; } $countDownload= $row_file[5]; ?>