Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure_Content.php	2.95 KB	-rwxr-xr-x
Structure_Content_Loop.php	2.92 KB	-rwxr-xr-x
Structure_Content_Loop_BETWEEN...	2.98 KB	-rwxr-xr-x
Structure_Content_Loop_LIMIT_D...	2.93 KB	-rwxr-xr-x
Structure_Content_Loop_LIMIT_N...	2.98 KB	-rwxr-xr-x
Structure_Content_Loop_LIMIT_N...	2.98 KB	-rwxr-xr-x
Structure_Content_Loop_NotShow...	2.96 KB	-rwxr-xr-x
Structure_Content_Loop_NotShow...	2.96 KB	-rwxr-xr-x
Structure_Content_check.php	928 B	-rwxr-xr-x
Structure_Home.php	2.29 KB	-rwxr-xr-x
Structure_Home2.php	2.29 KB	-rwxr-xr-x
Structure_HomeList.php	2.48 KB	-rwxr-xr-x
Structure_HomeList_Detail.php	2.48 KB	-rwxr-xr-x
Structure_Home_asc - Copy.php	2.33 KB	-rwxr-xr-x
Structure_Home_asc.php	2.29 KB	-rwxr-xr-x
Structure_Home_desc.php	2.29 KB	-rwxr-xr-x
Structure_ProductAndCategory.p...	2.42 KB	-rwxr-xr-x
Structure_about.php	2.33 KB	-rwxr-xr-x
Structure_article.php	1.6 KB	-rwxr-xr-x
Structure_member.php	2.92 KB	-rwxr-xr-x
Structure_outservices.php	1.21 KB	-rwxr-xr-x
Structure_product_category.php	840 B	-rwxr-xr-x
Structure_schedulet.php	2.26 KB	-rwxr-xr-x
Structure_vdo.php	1.17 KB	-rwxr-xr-x
index.php	0 B	-rwxr-xr-x

Code Editor : Structure_Content_Loop.php

<?PHP

//echo $HomeID ;
						$SQL_content ="
						SELECT content.Content_ID, content.CategoryContent_ID, category_content.CategoryContent_Name, content.CategoryContentLanguage_ID, category_content_language.CategoryContentLanguage_NameTH, category_content_language.CategoryContentLanguage_NameEN, category_content_language.CategoryContentLanguage_IMG, content.StatusContent_ID, status_content.StatusContent_Name, content.Member_ID, member.Member_PrefixNameEN, member.Member_NameEN, content.Content_Name, content.Content_Content1, content.Content_Content2, content.Content_Content3, content.Content_Content4, content.Content_Content5, content.Content_Sort, content.Content_Date, content.Content_Time, content.Content_Number, content.Content_Visitors, member.Position_ID, position.Position_Name FROM position INNER JOIN (member INNER JOIN (status_content INNER JOIN ((content INNER JOIN category_content ON content.CategoryContent_ID = category_content.CategoryContent_ID) INNER JOIN category_content_language ON content.CategoryContentLanguage_ID = category_content_language.CategoryContentLanguage_ID) ON status_content.StatusContent_ID = content.StatusContent_ID) ON member.Member_ID = content.Member_ID) ON position.Position_ID = member.Position_ID
 						WHERE 
						content.CategoryContentLanguage_ID = $CategoryContentLanguage_ID AND 
						content.CategoryContent_ID = $CategoryContent_ID AND
						content.StatusContent_ID = 1						
						ORDER BY content.Content_ID asc
						";			
							
						$objQuery_content = $objConnect->query($SQL_content);

/* 	while($objResult_Home = mysqli_fetch_array($objQuery_content)) {	
							
							
							$HomeID = $objResult_Home["Home_ID"];
							$HomeSub = $objResult_Home["Home_Sub"];
							$HomeShort = $objResult_Home["Home_Short"];
							$HomeDetail = $objResult_Home["Home_Detail"];
									
									
									// 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 	
									LIMIT 1
									";
									$objQuery_Home_Img = $objConnect->query($SQL_Home_Img);
									
						
					
					
										while($objResult_Home_Img= mysqli_fetch_array($objQuery_Home_Img)) {	
										
										$HomeID_Img = $objResult_Home_Img["Home_ID"];
										$HomeImg_Img = $objResult_Home_Img["ImgHome_Img"];
										
											echo	" HomeID_Img: ".$HomeID_Img;
											echo	" HomeImg_Img: ".$HomeImg_Img;
										
										}
										
										// END Show img only LIMIT 1

echo	" HomeID: ".$HomeID;
						echo	" HomeShort: ".$HomeShort;
						echo	" HomeSub: ".$HomeSub;
						echo	" HomeDetail: ".$HomeDetail;

}   */
						
						// END article
				
					
?>

${this.title}

Code Editor : Structure_Content_Loop.php