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

<?PHP

/* 	$SQL_Product ="
			SELECT product.Product_ID, product.ProductCategory_ID, product_category.ProductCategory_Name, 
			product.Product_Date ,product.Product_Time,
			product.ProductCategory2_ID, product_category2.ProductCategory2_Name,
			product.Member_ID, member.Member_NameEN, member.Position_ID, position.Position_Name, 
			product.Product_Name, product.Product_Num, product.Product_Unit, product.Product_Price,
			product.Product_Img, product.StatusProduct_ID, status_product.StatusProduct_Name,product.Product_Detail
			FROM status_product INNER JOIN (position INNER JOIN (member
			INNER JOIN (product_category2 INNER JOIN (product_category
			INNER JOIN product ON product_category.ProductCategory_ID = product.ProductCategory_ID) 
			ON product_category2.ProductCategory2_ID = product.ProductCategory2_ID) 
			ON member.Member_ID = product.Member_ID) 
			ON position.Position_ID = member.Position_ID) ON status_product.StatusProduct_ID = product.StatusProduct_ID
			WHERE product.StatusProduct_ID != 3
			ORDER BY product.Product_ID
			";		
			
	$objQuery_Produc= $objConnect->query($SQL_Product);		 */

/* 	 while($objResult_Produc= mysqli_fetch_array($objQuery_Produc)) {	
							
							$Product_ID = $objResult_Produc["Product_ID"];
							$Product_Name = $objResult_Produc["Product_Name"];
							$Product_Price = $objResult_Produc["Product_Price"];
							$Product_Detail = $objResult_Produc["Product_Detail"];
							$Product_Img = $objResult_Produc["Product_Img"];
							
								echo	" Product_ID: ".$Product_ID;
								echo	" Product_Name: ".$Product_Name;
								echo	" Product_Price: ".$Product_Price;
								echo	" Product_Detail: ".$Product_Detail;
								echo	" Product_Img: ".$Product_Img;
							
							}	 */
							
							$SQL_Category="
							SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name,
							product_category.StatusProductCategory_ID, status_productcategory.StatusProductCategory_Name,product_category.ProductCategory_img
							FROM status_productcategory INNER JOIN product_category ON status_productcategory.StatusProductCategory_ID = product_category.StatusProductCategory_ID
							WHERE product_category.StatusProductCategory_ID = 1
							ORDER BY product_category.ProductCategory_ID
							LIMIT 3
							";					
							$objQuery_Category= $objConnect->query($SQL_Category);

${this.title}

Code Editor : Structure_ProductAndCategory.php