query($SQL_Home);
while ($objResult_Home = mysqli_fetch_array($objQuery_Home)) {
$HomeID = $objResult_Home["Home_ID"];
$HomeSub = $objResult_Home["Home_Sub"];
$HomeShort = $objResult_Home["Home_Short"];
$HomeDetail = $objResult_Home["Home_Detail"];
$HomeShort2 = $objResult_Home["Home_Short2"];
$HomeShort3 = $objResult_Home["Home_Short3"];
$HomeDate = $objResult_Home["Home_Date"];
$StatusShowPageID = $objResult_Home["StatusShowPage_ID"];
$Home_Visitors = $objResult_Home["Home_Visitors"];
$date = date_create($HomeDate);
$NewDate = date_format($date, "F d , Y");
$NewDate1 = date_format($date, "d");
$NewDate2 = date_format($date, "F");
// Show img only LIMIT 1
$SQL_Home_Img = "
SELECT img_home.Home_ID, img_home.ImgHome_Img,
img_home.ImgHome_Sort, img_home.StatusImgHome_ID
FROM img_home
WHERE img_home.Home_ID = $HomeID
ORDER BY img_home.ImgHome_Sort ASC
";
$objQuery_Home_Img = $objConnect->query($SQL_Home_Img);
// พากหัว หลัก
if ($HomeSub == "-") {
$Check_HomeSub2 = "";
} else {
$Check_HomeSub2 = $HomeSub;
}
//map
if ($HomeShort == "-") {
$Check_HomeShort2 = "";
} else {
$Check_HomeShort2 = $HomeShort;
}
//เกริน
if ($HomeDetail == "-") {
$Check_HomeShort3 = "";
} else {
$Check_HomeShort3 = $HomeShort2;
}
//เวลา
if ($HomeDetail == "-") {
$Check_HomeShort4 = "";
} else {
$Check_HomeShort4 = $HomeShort3;
}
//รายละเอียด
if ($HomeDetail == "-") {
$Check_HomeDetai2 = "";
} else {
$Check_HomeDetai2 = $HomeDetail;
}
while ($objResult_Home_Img = mysqli_fetch_array($objQuery_Home_Img)) {
$HomeID_Img = $objResult_Home_Img["Home_ID"];
$HomeImg_Img = $objResult_Home_Img["ImgHome_Img"];
}
?>