Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure_Content.php	2.89 KB	-rw-r--r--
Structure_Content_Loop.php	2.85 KB	-rw-r--r--
Structure_Content_Loop_BETWEEN...	2.92 KB	-rw-r--r--
Structure_Content_Loop_LIMIT_D...	2.87 KB	-rw-r--r--
Structure_Content_Loop_LIMIT_N...	2.91 KB	-rw-r--r--
Structure_Content_Loop_LIMIT_N...	2.92 KB	-rw-r--r--
Structure_Content_Loop_NotShow...	2.9 KB	-rw-r--r--
Structure_Content_Loop_NotShow...	2.9 KB	-rw-r--r--
Structure_Content_check.php	885 B	-rw-r--r--
Structure_Home.php	2.22 KB	-rw-r--r--
Structure_Home2.php	2.22 KB	-rw-r--r--
Structure_HomeList.php	2.4 KB	-rw-r--r--
Structure_HomeList_Detail.php	2.4 KB	-rw-r--r--
Structure_Home_asc - Copy.php	2.27 KB	-rw-r--r--
Structure_Home_asc.php	2.22 KB	-rw-r--r--
Structure_Home_desc.php	2.23 KB	-rw-r--r--
Structure_ProductAndCategory.p...	2.37 KB	-rw-r--r--
Structure_about.php	2.26 KB	-rw-r--r--
Structure_article.php	1.56 KB	-rw-r--r--
Structure_member.php	2.85 KB	-rw-r--r--
Structure_outservices.php	1.18 KB	-rw-r--r--
Structure_product_category.php	819 B	-rw-r--r--
Structure_schedulet.php	2.21 KB	-rw-r--r--
Structure_vdo.php	1.14 KB	-rw-r--r--
index.php	169 B	-rwxr-xr-x

Code Editor : Structure_Content_Loop_LIMIT_DESC.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 DESC
						LIMIT $LIMIT
						";			
							
						$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_LIMIT_DESC.php