if($datac1['CatID'] == 317 || $datac1['CatID'] == 340){
?>
$rsctt=$db->Query("SELECT * FROM tour_cat WHERE CatID = $idtc");
$arrctt=mysql_fetch_array($rsctt);
?>
=$arrctt['CatTitle']?>
หน้าแรก
if($datac1['CatName'] <> "" ){ echo " / ".$datac1['CatName']." ";}?>
/ =$_GET['data']?>
}else{
?>
หน้าแรก / ทัวร์ต่างประเทศ
if($datac1['CatName'] <> "" ){ echo "/ ".$datac1['CatName']." ";}?>
/ =$_GET['data']?>
}
?>
$rsct=$db->Query("SELECT * FROM tour_cat WHERE CatParentID = $idmu");
while($arrct=mysql_fetch_array($rsct)){
?>
}
?>
$rst=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour_se_cat.$catsub = tour_cat.CatID AND tour_se_cat.tour_id = tour.id AND tour_tag.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour_tag.tourtag_name ORDER BY tour_tag.tourtag_name ASC ");
while($arrt=mysql_fetch_array($rst)){
?>
}
?>
if(!isset($start)){
$start = 0;
}
$limit = '10';
$item1 = 1;
if($_GET['type'] == 1){
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.price ASC ");
$arr=mysql_fetch_array($rs);
$count_data_manu = mysql_num_rows($rs);
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.price ASC LIMIT $start,$limit");
$count_data = mysql_num_rows($rs);
}elseif($_GET['type'] == 2){
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.price DESC ");
$arr=mysql_fetch_array($rs);
$count_data_manu = mysql_num_rows($rs);
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.price DESC LIMIT $start,$limit");
$count_data = mysql_num_rows($rs);
}elseif($_GET['type'] == 3){
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.Rating DESC,tour.id DESC ");
$arr=mysql_fetch_array($rs);
$count_data_manu = mysql_num_rows($rs);
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.Rating DESC,tour.id DESC LIMIT $start,$limit");
$count_data = mysql_num_rows($rs);
}else{
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.price ASC ");
$arr=mysql_fetch_array($rs);
$count_data_manu = mysql_num_rows($rs);
$rs=$db->Query("SELECT * FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour.tourExpress = 1 AND tour_se_cat.$catsub = tour_cat.CatID AND tour_tag.tour_id = tour.id AND tour_tag.tourtag_name = '".$_GET['data']."' AND tour_se_cat.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc GROUP BY tour.id ORDER BY tour.price ASC LIMIT $start,$limit");
$count_data = mysql_num_rows($rs);
}
?>
=$data['CatName']?> |
พบ =number_format($count_data_manu);?> โปรแกรมทัวร์ |
ค้นหาโปรแกรมทัวร์
10 อันดับ =$data['CatName']?>ขายดี
$rsct=$db->Query("SELECT * FROM tour_cat WHERE CatID = $idmu");
$arrct=mysql_fetch_array($rsct);
for($i=1;$i<=5;$i++){
$BS = "BS".$i;
if($arrct[$BS] > 0){
$rsbst=$db->Query("SELECT * FROM tour WHERE id = {$arrct[$BS]}");
$arrbst=mysql_fetch_array($rsbst);
$rssub=$db->Query("SELECT * FROM tour_content WHERE content_tour_id = '".$arrbst['id']."'");
$arrsub=mysql_num_rows($rssub);
$rsdd=$db->Query("SELECT * FROM tour_detailday WHERE tour_id = '".$arrbst['id']."'");
$arrdd=mysql_num_rows($rsdd);
if($arrsub > 0 || $arrdd > 0){
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
}else{
if($arrbst['pdf'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/pdf/".$arrbst['pdf']."\"";
}elseif($arrbst['fileload'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/word/".$arrbst['fileload']."\"";
}else{
$goto = "href=\"#\"";
}
}
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
$data=$db->getRow('tour_photo',"WHERE id ='{$arrbst['id']}' ORDER BY id_p ASC ");
?>
}
}
?>
$rsct=$db->Query("SELECT * FROM tour_cat WHERE CatID = $idmu");
$arrct=mysql_fetch_array($rsct);
for($i=1;$i<=5;$i++){
$RM = "RM".$i;
if($arrct[$RM] > 0){
$rsbst=$db->Query("SELECT * FROM tour WHERE id = {$arrct[$RM]}");
$arrbst=mysql_fetch_array($rsbst);
$rssub=$db->Query("SELECT * FROM tour_content WHERE content_tour_id = '".$arrbst['id']."'");
$arrsub=mysql_num_rows($rssub);
$rsdd=$db->Query("SELECT * FROM tour_detailday WHERE tour_id = '".$arrbst['id']."'");
$arrdd=mysql_num_rows($rsdd);
if($arrsub > 0 || $arrdd > 0){
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
}else{
if($arrbst['pdf'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/pdf/".$arrbst['pdf']."\"";
}elseif($arrbst['fileload'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/word/".$arrbst['fileload']."\"";
}else{
$goto = "href=\"#\"";
}
}
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
$data=$db->getRow('tour_photo',"WHERE id ='{$arrbst['id']}' ORDER BY id_p ASC ");
?>
}
}
?>
>=$arrbst['name'];?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
ราคาเริ่มต้น =number_format($arrbst['price']);?>
>=$arrbst['name'];?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
ราคาเริ่มต้น =number_format($arrbst['price']);?>
TAG
$rst=$db->Query("SELECT DISTINCT tourtag_name FROM tour,tour_cat,tour_se_cat,tour_tag WHERE tour_se_cat.$catsub = tour_cat.CatID AND tour_se_cat.tour_id = tour.id AND tour_tag.tour_id = tour.id AND tour.public = 1 AND tour_se_cat.$catsub = $idtc ORDER BY tour_tag.tourtag_name ASC ");
while($arrt=mysql_fetch_array($rst)){
?>
=$arrt['tourtag_name']?>,
}
?>
=$arrctt['TCatTitle']?>
while($arr=mysql_fetch_array($rs)){
$rssub=$db->Query("SELECT * FROM tour_content WHERE content_tour_id = '".$arr['id']."'");
$arrsub=mysql_num_rows($rssub);
if($arrsub > 0){
$goto = " target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour-detail.php?data=".$arr['title']."\"";
}
if($arr['pdf'] <> ""){
$gotod = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/pdf/".$arr['pdf']."\"";
}elseif($arr['fileload'] <> ""){
$gotod = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/word/".$arr['fileload']."\"";
}else{
$gotod = "href=\"#\"";
}
$goto = " target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour-detail.php?data=".$arr['title']."\"";
?>
$item1++;
}
?>
$idmu=$_GET['ids'];
$idtc=$_GET['ids'];
$catsub="catsub2";
$catsubn="catsub3";
$data=$db->getDataOneRow('tour_cat',$idtc,'CatID');
?>
$data=$db->getRow('tour_photo',"WHERE id ='{$arr['id']}' ORDER BY id_p ASC ");
?>
$rsc02=$db->Query("SELECT * FROM tour_cat WHERE CatID ='{$arr['catagory']}'");
$arrc02=mysql_fetch_array($rsc02);
$rsc12=$db->Query("SELECT * FROM tour_cat WHERE CatID ='{$arr['catsub2']}'");
$arrc12=mysql_fetch_array($rsc12);
$rsc22=$db->Query("SELECT * FROM tour_cat WHERE CatID ='{$arr['catsub3']}'");
$arrc22=mysql_fetch_array($rsc22);
?>
เส้นทาง : =$arrc02['CatName'];?> =$arrc12['CatName'];?> =$arrc22['CatName'];?>
รหัสทัวร์ : =$arr['code'];?>
จำนวนวันเดินทาง : =$arr['days'];?>
if($arr['exprice'] > 0){
?>
if($arr['airline'] <> ""){
?>
รหัสทัวร์ : =$arr['code'];?>
จำนวนวันเดินทาง : =$arr['days'];?>
ราคาปกติ=number_format($arr['price']);?>
ราคาพิเศษ=number_format($arr['exprice']);?>
}else{
?>
ราคาปกติ=number_format($arr['price']);?>
ราคาพิเศษ=number_format($arr['exprice']);?>
}
?>
}else{
?>
if($arr['airline'] <> ""){
?>
ราคา=number_format($arr['price']);?>
}else{
?>ราคา=number_format($arr['price']);?>
}
?>
}
?>
if($arr['credit'] <> ""){
?>
}else{
?>
}
?>
![<?=$arr['credit']?> <?=$arr['credit']?>](https://www.tourxpresscenter.com/img/<?=$arr['credit']?>.jpg)
=$arr['Detail']?>
$comment=$db->getDataOneRow('time_schedule_comment',$arr['id'],'tour_id');
if($comment['detail'] <> ""){
?>
=$comment['detail']?>
}
?>
$CoTa = 2;
$rowchk="";
$rs1=$db->Query("SELECT * FROM time_schedule1 WHERE tour_id = {$arr['id']} AND start_date >= '".date("Y-m-d")."' ORDER BY start_date ASC ");
while($arr1=mysql_fetch_array($rs1)){
$dataSub = explode ( "-", $arr1['start_date'] );
if($arr1['tour_id']<>""){
if($CoTa%2==0){
$CoT = "preriod-1";
}else{
$CoT = "preriod-2";
}
if($rowchk <> $dataSub[1]){
$rowchk = $dataSub[1];
?>
$CoTa++;
}
}
}
?>
if(($dataSub[1] == "1") || ($dataSub[1] == "01")){
echo "มกราคม";
}elseif(($dataSub[1] == "2") || ($dataSub[1] == "02")){
echo "กุมภาพันธ์";
}elseif(($dataSub[1] == "3") || ($dataSub[1] == "03")){
echo "มีนาคม";
}elseif(($dataSub[1] == "4") || ($dataSub[1] == "04")){
echo "เมษายน";
}elseif(($dataSub[1] == "5") || ($dataSub[1] == "05")){
echo "พฤษภาคม";
}elseif(($dataSub[1] == "6") || ($dataSub[1] == "06")){
echo "มิถุนายน";
}elseif(($dataSub[1] == "7") || ($dataSub[1] == "07")){
echo "กรกฎาคม";
}elseif(($dataSub[1] == "8") || ($dataSub[1] == "08")){
echo "สิงหาคม";
}elseif(($dataSub[1] == "9") || ($dataSub[1] == "09")){
echo "กันยายน";
}elseif(($dataSub[1] == "10") || ($dataSub[1] == "10")){
echo "ตุลาคม";
}elseif(($dataSub[1] == "11") || ($dataSub[1] == "11")){
echo "พฤศจิกายน";
}elseif(($dataSub[1] == "12") || ($dataSub[1] == "12")){
echo "ธันวาคม";
}
?>
$rs2=$db->Query("SELECT * FROM time_schedule1 WHERE start_date LIKE '{$dataSub[0]}-{$dataSub[1]}-%' AND start_date >= '".date("Y-m-d")."' AND tour_id = {$arr['id']} ORDER BY start_date ASC ");
while($arr2=mysql_fetch_array($rs2)){
$dataSub2 = explode ( "-", $arr2['start_date'] );
$dataSub3 = explode ( "-", $arr2['end_date'] );
?>
>
if($dataSub2[1] <> $dataSub3[1]){
echo $dataSub2[2]." ";
if(($dataSub2[1] == "1") || ($dataSub2[1] == "01")){
echo "ม.ค.";
}elseif(($dataSub2[1] == "2") || ($dataSub2[1] == "02")){
echo "ก.พ.";
}elseif(($dataSub2[1] == "3") || ($dataSub2[1] == "03")){
echo "มี.ค.";
}elseif(($dataSub2[1] == "4") || ($dataSub2[1] == "04")){
echo "เม.ย.";
}elseif(($dataSub2[1] == "5") || ($dataSub2[1] == "05")){
echo "พ.ค.";
}elseif(($dataSub2[1] == "6") || ($dataSub2[1] == "06")){
echo "มิ.ย.";
}elseif(($dataSub2[1] == "7") || ($dataSub2[1] == "07")){
echo "ก.ค.";
}elseif(($dataSub2[1] == "8") || ($dataSub2[1] == "08")){
echo "ส.ค.";
}elseif(($dataSub2[1] == "9") || ($dataSub2[1] == "09")){
echo "ก.ย.";
}elseif(($dataSub2[1] == "10") || ($dataSub2[1] == "10")){
echo "ต.ค.";
}elseif(($dataSub2[1] == "11") || ($dataSub2[1] == "11")){
echo "พ.ย.";
}elseif(($dataSub2[1] == "12") || ($dataSub2[1] == "12")){
echo "ธ.ค.";
}
echo " - ".$dataSub3[2]." ";
if(($dataSub3[1] == "1") || ($dataSub3[1] == "01")){
echo "ม.ค.";
}elseif(($dataSub3[1] == "2") || ($dataSub3[1] == "02")){
echo "ก.พ.";
}elseif(($dataSub3[1] == "3") || ($dataSub3[1] == "03")){
echo "มี.ค.";
}elseif(($dataSub3[1] == "4") || ($dataSub3[1] == "04")){
echo "เม.ย.";
}elseif(($dataSub3[1] == "5") || ($dataSub3[1] == "05")){
echo "พ.ค.";
}elseif(($dataSub3[1] == "6") || ($dataSub3[1] == "06")){
echo "มิ.ย.";
}elseif(($dataSub3[1] == "7") || ($dataSub3[1] == "07")){
echo "ก.ค.";
}elseif(($dataSub3[1] == "8") || ($dataSub3[1] == "08")){
echo "ส.ค.";
}elseif(($dataSub3[1] == "9") || ($dataSub3[1] == "09")){
echo "ก.ย.";
}elseif(($dataSub3[1] == "10") || ($dataSub3[1] == "10")){
echo "ต.ค.";
}elseif(($dataSub3[1] == "11") || ($dataSub3[1] == "11")){
echo "พ.ย.";
}elseif(($dataSub3[1] == "12") || ($dataSub3[1] == "12")){
echo "ธ.ค.";
}
$dataSub3[0] = $dataSub3[0] + 543;
echo " ".substr ( $dataSub3[0], 2 );
?>
=$arr2['comment'];?>=", ";?>
}else{
echo $dataSub2[2]." - ".$dataSub3[2]." ";
if(($dataSub2[1] == "1") || ($dataSub2[1] == "01")){
echo "ม.ค.";
}elseif(($dataSub2[1] == "2") || ($dataSub2[1] == "02")){
echo "ก.พ.";
}elseif(($dataSub2[1] == "3") || ($dataSub2[1] == "03")){
echo "มี.ค.";
}elseif(($dataSub2[1] == "4") || ($dataSub2[1] == "04")){
echo "เม.ย.";
}elseif(($dataSub2[1] == "5") || ($dataSub2[1] == "05")){
echo "พ.ค.";
}elseif(($dataSub2[1] == "6") || ($dataSub2[1] == "06")){
echo "มิ.ย.";
}elseif(($dataSub2[1] == "7") || ($dataSub2[1] == "07")){
echo "ก.ค.";
}elseif(($dataSub2[1] == "8") || ($dataSub2[1] == "08")){
echo "ส.ค.";
}elseif(($dataSub2[1] == "9") || ($dataSub2[1] == "09")){
echo "ก.ย.";
}elseif(($dataSub2[1] == "10") || ($dataSub2[1] == "10")){
echo "ต.ค.";
}elseif(($dataSub2[1] == "11") || ($dataSub2[1] == "11")){
echo "พ.ย.";
}elseif(($dataSub2[1] == "12") || ($dataSub2[1] == "12")){
echo "ธ.ค.";
}
$dataSub2[0] = $dataSub2[0] + 543;
echo " ".substr ( $dataSub2[0], 2 );
?>
=$arr2['comment'];?>=", ";?>
}
?>
}
?>
10 อันดับ =$data['CatName']?>ขายดี
$rsct=$db->Query("SELECT * FROM tour_cat WHERE CatID = $idmu");
$arrct=mysql_fetch_array($rsct);
for($i=1;$i<=5;$i++){
$BS = "BS".$i;
if($arrct[$BS] > 0){
$rsbst=$db->Query("SELECT * FROM tour WHERE id = {$arrct[$BS]}");
$arrbst=mysql_fetch_array($rsbst);
$rssub=$db->Query("SELECT * FROM tour_content WHERE content_tour_id = '".$arrbst['id']."'");
$arrsub=mysql_num_rows($rssub);
$rsdd=$db->Query("SELECT * FROM tour_detailday WHERE tour_id = '".$arrbst['id']."'");
$arrdd=mysql_num_rows($rsdd);
if($arrsub > 0 || $arrdd > 0){
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
}else{
if($arrbst['pdf'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/pdf/".$arrbst['pdf']."\"";
}elseif($arrbst['fileload'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/word/".$arrbst['fileload']."\"";
}else{
$goto = "href=\"#\"";
}
}
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
$data=$db->getRow('tour_photo',"WHERE id ='{$arrbst['id']}' ORDER BY id_p ASC ");
?>
}
}
?>
$rsct=$db->Query("SELECT * FROM tour_cat WHERE CatID = $idmu");
$arrct=mysql_fetch_array($rsct);
for($i=1;$i<=5;$i++){
$RM = "RM".$i;
if($arrct[$RM] > 0){
$rsbst=$db->Query("SELECT * FROM tour WHERE id = {$arrct[$RM]}");
$arrbst=mysql_fetch_array($rsbst);
$rssub=$db->Query("SELECT * FROM tour_content WHERE content_tour_id = '".$arrbst['id']."'");
$arrsub=mysql_num_rows($rssub);
$rsdd=$db->Query("SELECT * FROM tour_detailday WHERE tour_id = '".$arrbst['id']."'");
$arrdd=mysql_num_rows($rsdd);
if($arrsub > 0 || $arrdd > 0){
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
}else{
if($arrbst['pdf'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/pdf/".$arrbst['pdf']."\"";
}elseif($arrbst['fileload'] <> ""){
$goto = "target=\"_blank\" href=\"https://www.tourxpresscenter.com/tour/word/".$arrbst['fileload']."\"";
}else{
$goto = "href=\"#\"";
}
}
$goto = " href=\"https://www.tourxpresscenter.com/tour-detail.php?id=".$arrbst['title']."\"";
$data=$db->getRow('tour_photo',"WHERE id ='{$arrbst['id']}' ORDER BY id_p ASC ");
?>
}
}
?>
>=$arrbst['name'];?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
ราคาเริ่มต้น =number_format($arrbst['price']);?>
>=$arrbst['name'];?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
เดินทาง $data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM >= ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "ธ.ค."; } $data['checkM']=(int)$data['checkM']+1; //$data=$db->getRow('time_schedule1',"WHERE tour_id ='{$arrbst['id']}' AND checkM > ".date('m')." ORDER BY start_date ASC "); if(($data['checkM'] == "1") || ($data['checkM'] == "01")){ echo "-ม.ค."; }elseif(($data['checkM'] == "2") || ($data['checkM'] == "02")){ echo "-ก.พ."; }elseif(($data['checkM'] == "3") || ($data['checkM'] == "03")){ echo "-มี.ค."; }elseif(($data['checkM'] == "4") || ($data['checkM'] == "04")){ echo "-เม.ย."; }elseif(($data['checkM'] == "5") || ($data['checkM'] == "05")){ echo "-พ.ค."; }elseif(($data['checkM'] == "6") || ($data['checkM'] == "06")){ echo "-มิ.ย."; }elseif(($data['checkM'] == "7") || ($data['checkM'] == "07")){ echo "-ก.ค."; }elseif(($data['checkM'] == "8") || ($data['checkM'] == "08")){ echo "-ส.ค."; }elseif(($data['checkM'] == "9") || ($data['checkM'] == "09")){ echo "-ก.ย."; }elseif(($data['checkM'] == "10") || ($data['checkM'] == "10")){ echo "-ต.ค."; }elseif(($data['checkM'] == "11") || ($data['checkM'] == "11")){ echo "-พ.ย."; }elseif(($data['checkM'] == "12") || ($data['checkM'] == "12")){ echo "-ธ.ค."; } ?>
ราคาเริ่มต้น =number_format($arrbst['price']);?>
=$data['CatDetail']?>
