Gecko [ myeducation.co.th ]

Name	Size	Permission	Action
Structure_Home_DESC.php	2.29 KB	-rwxr-xr-x
Structure_Home_asc.php	2.29 KB	-rwxr-xr-x

Code Editor : Structure_Home_asc.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_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 = 1 AND home.StatusShowPage_ID = '$HomeID'
						ORDER BY home.Home_ID DESC
						";			
							
						$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_Home_asc.php