bob815 Posted August 3, 2010 Posted August 3, 2010 Can anyone point me in the right direction to fix this? 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 '//ind_ship---start FROM products p JOIN products_to_c' at line 17 SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_status as v_status, p.products_price as v_products_price, ps.products_ship_price as v_products_ship_price, ps.products_ship_price_two as v_products_ship_price_two, p.products_quantity as v_products_quantity, p.products_weight as v_products_weight, p.products_image as v_products_image, p.manufacturers_id as v_manufacturers_id, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, subc.categories_id as v_categories_id //ind_ship---start FROM products p JOIN products_to_categories ptoc ON ptoc.products_id=p.products_id JOIN categories subc ON subc.categories_id=ptoc.categories_id LEFT JOIN products_shipping ps ON p.products_id=ps.products_id and (ptoc.categories_id = 25 or ptoc.categories_id = 148 or ptoc.categories_id = 147 or ptoc.categories_id = 39 or ptoc.categories_id = 40 or ptoc.categories_id = 41 or ptoc.categories_id = 42 or ptoc.categories_id = 43 or ptoc.categories_id = 44 or ptoc.categories_id = 45 or ptoc.categories_id = 46 or ptoc.categories_id = 47 or ptoc.categories_id = 48 or ptoc.categories_id = 49 or ptoc. categories_id = 50 or ptoc.categories_id = 51 or ptoc.categories_id = 52 or ptoc.categories_id = 53 or ptoc.categories_id = 54 or ptoc.categories_id = 55 or ptoc.categories_id = 57 or ptoc.categories_id = 58 or ptoc.categories_id = 149 or ptoc.categories_id = 150) [TEP STOP] Thanks....Bob Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.