Northwind Posted August 27, 2004 Share Posted August 27, 2004 Hello all, I imagine this one should be an easy one for the sql+php pros out there...but that's not me so...lol Anyway - on displaying an article, I get this Xsell error down at the bottom of the page. Any ideas? 1064 - You have an error in your SQL syntax near 'Maximum number of products to display in the articles Cross-Sell listing.' at line 1 select distinct a.products_id, a.products_image, ad.products_name from articles_xsell ax, products a, products_description ad where ax.articles_id = '1' and ax.xsell_id = a.products_id and a.products_id = ad.products_id and ad.language_id = '1' and a.products_status = '1' order by ax.sort_order asc limit Maximum number of products to display in the articles Cross-Sell listing. [TEP STOP] That part ", ad where " looks suspicious to me, as I can't think of what the ad is but then again I maybe totally wrong. Please someone let me know. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.