Gecko [ myeducation.co.th ]

Name	Size	Permission
Structure_Home.php	2.33 KB	-rw-r--r--
Structure_Home2.php	2.33 KB	-rw-r--r--
Structure_HomeList.php	2.52 KB	-rw-r--r--
Structure_HomeList_Detail.php	2.52 KB	-rw-r--r--
Structure_Home_asc - Copy.php	2.33 KB	-rw-r--r--
Structure_Home_asc.php	2.33 KB	-rw-r--r--
Structure_Home_desc.php	2.33 KB	-rw-r--r--
Structure_ProductAndCategory.p...	2.42 KB	-rw-r--r--
Structure_about.php	2.33 KB	-rw-r--r--
Structure_article.php	1.6 KB	-rw-r--r--
Structure_member.php	2.92 KB	-rw-r--r--
Structure_outservices.php	1.21 KB	-rw-r--r--
Structure_product_category.php	840 B	-rw-r--r--
Structure_schedulet.php	2.26 KB	-rw-r--r--
Structure_vdo.php	956 B	-rw-r--r--

Code Editor : Structure_Home2.php

<?PHP

//echo $HomeID ;
			$SQL_Home="
			SELECT home.Home_ID, home.Member_ID, member.Member_NameEN, member.Position_ID, 
			position.Position_Name, home.Home_Date, home.Home_Time, home.Home_Visitors, home.Home_Sub, 
			home.Home_Short,home.Home_Short2,home.Home_Short3, 
			home.Home_Detail, home.Home_Category, home.StatusHome_ID, 
			status_home.StatusHome_Name, home.StatusShowPage_ID, status_showpage.StatusShowPage_Name
			FROM status_showpage INNER JOIN (status_home 
			INNER JOIN (position INNER JOIN (member
			INNER JOIN home ON member.Member_ID = home.Member_ID) 
			ON position.Position_ID = member.Position_ID)
			ON status_home.StatusHome_ID = home.StatusHome_ID) 
			ON status_showpage.StatusShowPage_ID = home.StatusShowPage_ID
			WHERE home.StatusHome_ID != 2 AND home.StatusShowPage_ID = '$StatusShowPage'
			ORDER BY home.Home_ID	desc			
			LIMIT $StatusShowPage_LIMIT		
			";			
							
						$objQuery_Home= $objConnect->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"];
									
									
									// 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_Home2.php