Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

A little help with a query please


mark27uk3

Recommended Posts

Hi,

 

After many hours of staring at query after query and generally doing to much work for a sunday I would like to ask for help.

 

I need to add the CATEGORIES_DESCRIPTION table into this query so I can pull out the categories name:

 

  $products=tep_db_query("select * from ".TABLE_PRODUCTS." left join ".TABLE_PRODUCTS_DESCRIPTION." using(products_id) left join ".TABLE_PRODUCTS_TO_CATEGORIES." using(products_id) where language_id='".$languages_id."' and categories_id in (".implode($categories_ids, ', ').")");

 

If I am not getting syntax errors I am getting that the language is ambiguos :'(

 

Any help would be appreciated.

 

Thanks

Lifes a bitch, then you marry one, then you die!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...