[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