Hi Dan,
Sorry, I slipped. Need to add "
cat.orderby,".
Alex
Quote:
|
Originally Posted by info@sjidesign.com
Hi Alex,
Thank you very much for the reply but when I put that code in my product.php I get the error.
INVALID SQL: 1054 : Unknown column 'pr.orderby' in 'order clause'
SQL QUERY FAILURE:SELECT pr.productid, pr.product, mem.membershipid FROM xcart_products_categories AS cat, xcart_products AS pr LEFT JOIN xcart_product_memberships AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '71' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.orderby, pr.product
Any ideas what's wrong?
Thanks again for your help.
Regards
Dan
|