Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Syntax help needed for mySQL query, please.


ohduh!

Recommended Posts

Hi,

 

I'm trying to pull in the manufacturer's name into the product_info.php page and am running into problems with my syntax. Help please?

 

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 'from products p, manufacturers m, products_description pd where

select p.products_id, pd.products_name, pd.products_artist, pd.products_year, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, m.manufacturers_name, from products p, manufacturers m, products_description pd where p.products_status = '1' and p.products_id = '33' and pd.products_id = p.products_id and pd.language_id = '1'

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...