query($SQL_Category);
while ($objResult_category = mysqli_fetch_array($objQuery_Category)) {
$ProductCategoryID = $objResult_category["ProductCategory_ID"];
$ProductCategoryName = $objResult_category["ProductCategory_Name"];
$ProductCategory1_ahref_name = $objResult_category["ProductCategory_ahref_name"];
$ProductCategory1_ahref_status = $objResult_category["ProductCategory_ahref_status"];
$SQL_Category2 = "
SELECT product_category.ProductCategory_ID, product_category.ProductCategory_Name,
product_category.StatusProductCategory_ID, product_category2.ProductCategory2_ID,
product_category2.StatusProductCategory2_ID,
product_category2.ProductCategory2_ahref_name , product_category2.ProductCategory2_ahref_status,
product_category2.ProductCategory2_Name
FROM product_category2 INNER JOIN product_category
ON product_category2.ProductCategory_ID = product_category.ProductCategory_ID
WHERE product_category2.StatusProductCategory2_ID = 1 AND
product_category.ProductCategory_ID = $ProductCategoryID
ORDER BY product_category.ProductCategory_ID
";
$objQuery_Category2 = $objConnect->query($SQL_Category2);
?>
query($SQL_Category);
while ($objResult_category = mysqli_fetch_array($objQuery_Category)) {
$ProductCategoryID = $objResult_category["ProductCategory_ID"];
$ProductCategoryName = $objResult_category["ProductCategory_Name"];
$ProductCategoryDetail = $objResult_category["ProductCategory_Detail"];
$ProductCategoryIMG = $objResult_category["ProductCategory_img"];
$ProductCategoryID = $objResult_category["ProductCategory_ID"];
?>
