attached is my current category page. (dynamic)
unable to fetch product under same category.
category-details uses 'CategoryLink' from productcategories table.
this needs to be linked with 'ProductCategoryID' from products table with CategoryID from productcategories table.
SELECT products.*, productcategories.*
FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID
WHERE products.ProductCategoryID = colname1
colnam1 value: $row_categories['CategoryID']
I know this is stupid but i m not able to fix this.
I don't know how do we filter this type of situation.
