1064 You have an error in your SQL syntax

lim0508

我的zen-cart 出现
1064 You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ')' at line 6
in:
[select distinct p.products_id, p.products_image,p.products_tax_class_id, pd.products_name, p.products_date_added,p.products_price, p.products_type, p.master_categories_id fromzen_products p, zen_products_description pd where p.products_id =pd.products_id and pd.language_id = '1' and p.products_id in (15, 18,19, 25, 28, 31, 33, 44, 47, 50, 52, 34, 51, 35, 36, 37, 40, 45, 48, 49,38, 39, 41, 42, 43, 46, 17, 14, 16, 20, 21, 22, 23, 24, 26, 27, 29,32,)]

请各位大大帮帮忙，谢谢

小陈陈

select distinct p.products_id, p.products_image,p.products_tax_class_id, pd.products_name, p.products_date_added,p.products_price, p.products_type, p.master_categories_id fromzen_product <- ????

联在一起???

神仙祖宗

原帖由 lim0508 于 22-8-2008 01:01 PM 发表
[select distinct p.products_id, p.products_image,p.products_tax_class_id, pd.products_name, p.products_date_added,p.products_price, p.products_type, p.master_categories_id fromzen_products p, zen_products_description pd where p.products_id =pd.products_id and pd.language_id = '1' and p.products_id in (15, 18,19, 25, 28, 31, 33, 44, 47, 50, 52, 34, 51, 35, 36, 37, 40, 45, 48, 49,38, 39, 41, 42, 43, 46, 17, 14, 16, 20, 21, 22, 23, 24, 26, 27, 29,32,)]

红色地方多了个“，”逗号