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

<?PHP

// article
						$SQL_Article="
							SELECT article.Article_ID, article.Article_Sub, 
							article.Article_Short, article.Article_Detail, 
							article.Member_ID, member.Member_PrefixNameTH,
							member.Member_NameTH, member.Member_PrefixNameEN, 
							member.Member_NameEN, member.Position_ID, position.Position_Name,
							article.Article_Date, article.Article_Time, article.Article_Img,
							article.StatusArticle_ID, status_article.StatusArticle_Name,
							article.Article_Category, article.Article_Visitors
							FROM position INNER JOIN (member INNER JOIN (status_article INNER JOIN article 
							ON status_article.StatusArticle_ID = article.StatusArticle_ID) ON member.Member_ID = article.Member_ID) ON position.Position_ID = member.Position_ID
							WHERE article.StatusArticle_ID != 3
							ORDER BY article.Article_ID
							";					
						$objQuery_Article= $objConnect->query($SQL_Article);					
						
							while($objResult_Article = mysqli_fetch_array($objQuery_Article)) {

$ArticleID = $objResult_Article["Article_ID"];
							$ArticleSub = $objResult_Article["Article_Sub"];
							$ArticleShort = $objResult_Article["Article_Short"];
							$ArticleDetail = $objResult_Article["Article_Detail"];
							$ArticleImg = $objResult_Article["Article_Img"];
							
					/* 	echo	" ArticleID: ".$ArticleID;
						echo	" ArticleSub: ".$ArticleSub;
						echo	" ArticleShort: ".$ArticleShort;
						echo	" ArticleDetail: ".$ArticleDetail;
						echo	" ArticleImg: ".$ArticleImg; */
							
							}
				// END article
				
					
?>

${this.title}

Code Editor : Structure_article.php