Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

A little help with a query please


Recommended Posts



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.



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

Link to comment
Share on other sites


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

  • Create New...