sub nav
Hi Ray
Rather than clutter up a different thread (namely this one thought I would start a new one.
IN that reffed thread, I asked about the sub navigation in post #3 and you replied with post #4 basically showing the below recordset:
SELECT productcategories.*, catParent.CategoryPermalink as ParentPermalink FROM productcategories INNER JOIN productcategories AS catParent ON catParent.CategoryID = productcategories.CategoryParentID WHERE catParent.CategoryID = (SELECT CategoryParentID FROM products INNER JOIN productcategories ON CategoryID = ProductCategoryID WHERE ProductPermalink = ?) AND Live = 1
I changed it to this
SELECT productcategories.*, catParent.CatPermalink as ParentPermalink FROM productcategories INNER JOIN productcategories AS catParent ON catParent.CategoryID = productcategories.CategoryParentID WHERE catParent.CategoryID = (SELECT CategoryParentID FROM products INNER JOIN productcategories ON CategoryID = ProductCategoryID WHERE ProdPermalink = ?)
and now am not getting the error in sql syntax but there are no results showing
apprecaite any steering in the right direction please