Another Related Question
Sorry - now I'm trying to change intermediate.php so the the CategoryID list in ascending order and not having any luck. Again assuming its this snippet that needs to be changed:
SELECT * FROM productcategories WHERE CategoryID = (SELECT ProductCategoryID FROM products WHERE ProductCategoryID = CategoryID AND ProductLive <> 0 LIMIT 1)
I tried adding ASC in various places - no luck.
Thank you - very appreciative.....