Syntax help needed for mySQL query, please.

[ohduh!]

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'

[OceanRanch]

Try changing

 

m.manufacturers_name,

 

to

 

m.manufacturers_name

 

HTH

Tom

[ohduh!]

Thanks Tom! That seems to have done the trick.