Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...