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_schedulet.php

<?PHP

$SQL_Schedulet ="
				SELECT schedulet.Schedulet_ID, schedulet.Schedulet_Sub, schedulet.Schedulet_Short,schedulet.Schedulet_Detail,
					schedulet.Schedulet_Img, schedulet.Schedulet_Date, schedulet.Schedulet_Time, 
					schedulet.Schedulet_DateAccess,schedulet.Schedulet_DateEnd,schedulet.Schedulet_TimeAccess,
					schedulet.Member_ID, member.Member_NameEN, member.Position_ID,schedulet.Schedulet_TimeEnd,
					position.Position_Name,
					position.Position_Name, schedulet.StatusSchedulet_ID, status_schedulet.StatusSchedulet_Name
					FROM position INNER JOIN (member INNER JOIN (status_schedulet INNER 
					JOIN schedulet 
					ON status_schedulet.StatusSchedulet_ID = schedulet.StatusSchedulet_ID) 
					ON member.Member_ID = schedulet.Member_ID) ON position.Position_ID = member.Position_ID
				WHERE schedulet.StatusSchedulet_ID = 1
				ORDER BY schedulet.Schedulet_ID
				";					
				$objQuery_Schedulet = $objConnect->query($SQL_Schedulet);	
				
				/* while($objResult_Schedulet= mysqli_fetch_array($objQuery_Schedulet)) {
					 
					$ScheduletID = $objResult_Schedulet["Schedulet_ID"];
					$ScheduletSub = $objResult_Schedulet["Schedulet_Sub"];
					$ScheduletShort = $objResult_Schedulet["Schedulet_Short"];
					$ScheduletDetail = $objResult_Schedulet["Schedulet_Detail"];
					
					$ScheduletImg = $objResult_Schedulet["Schedulet_Img"]; 
					
					$ScheduletDateAccess = $objResult_Schedulet["Schedulet_DateAccess"];
					$ScheduletDateEnd = $objResult_Schedulet["Schedulet_DateEnd"];
					
					$ScheduletTimeAccess = $objResult_Schedulet["Schedulet_TimeAccess"];
					$ScheduletTimeEnd = $objResult_Schedulet["Schedulet_TimeEnd"];
					
					$PositionName = $objResult_Schedulet["Position_Name"];
					
					echo	" ScheduletID: ".$ScheduletID;
					 echo	" ScheduletShort: ".$ScheduletShort;
					 echo	" ScheduletDetail: ".$ScheduletDetail;			
					 
					 echo	" ScheduletImg: ".$ScheduletImg;		
					 
					 echo	" ScheduletDateAccess: ".$ScheduletDateAccess;					 
					 echo	" ScheduletDateEnd: ".$ScheduletDateEnd;		
					 
					 echo	" ScheduletTimeAccess: ".$ScheduletTimeAccess;					 
					 echo	" ScheduletTimeEnd: ".$ScheduletTimeEnd;					 
			
					 
					 } */
				
					
?>

${this.title}

Code Editor : Structure_schedulet.php