MySQL Forums
Forum List  »  PHP

Problem In running the query!
Posted by: Mohammed Maqsood
Date: February 17, 2006 12:56AM

Hi All,

1054 - Unknown column 'p.manufacturers_id' in 'on clause'

select count(*) as total from oc_products p, oc_products_description pd, oc_specials s, oc_products_to_categories pc LEFT JOIN oc_manufacturers m ON m.manufacturers_id = p.manufacturers_id LEFT JOIN oc_networks n ON n.network_id = p.network_id where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id AND p.products_id = pc.products_id and pd.language_id = '1' and s.status = '1' and pc.categories_id = 23

wats wrong in the query,

its workin good in server which has mysql 4... some thing and i have in my local server mysql 5...some thing

plz reply ....

Options: ReplyQuote


Subject
Written By
Posted
Problem In running the query!
February 17, 2006 12:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.