sorry but then i changed so that its clear.
catlink is now CategoryLink.
in the recordset, filter using the Categorylink column and the catlink URL variable.
Now i m bit confused here.
I earlier got this sql_join as you mentioned above & used it to display category name by filter ie.:
SELECT products.ProductID, productcategories.CategoryName, products.ProductCategoryID
FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID
WHERE products.ProductID = colname1
colname1 value : $row_WADAproducts['ProductID']
Now if i use same logic on display products it doesn't seem to work.
I got this :
SELECT products.*, productcategories.*
FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID
WHERE products.ProductCategoryID = colname1
Colname1 : $row_categories['CategoryID']
