Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

whats wrong with this MySQL database_query?


Recommended Posts

It nearly works


$products_query = tep_db_query("SELECT p.products_id, pd.products_name, p.products_rating, p.products_price, p.products_quantity, p.products_tax_class_id, cd.categories_name FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE p.products_id = pd.products_id AND pc.products_id = cd.categories_id AND pd.language_id = $this_language_id ORDER BY pd.products_name");


its really slow too...

Link to comment
Share on other sites

It doesnt give any error but I know its wrong because its not showing all the results correctly, about 1/3 of the products show - where as I need all my products to show.



Link to comment
Share on other sites

I would recommend checking the database to ensure that all of your data is there for sure. Easy way to do this is to simply use phpMyAdmin and click Browse on that particular table.


SOunds like you just need to do some troubleshooting. Take your time, be thorough, and you will find it.




Chris Sullivan

Link to comment
Share on other sites


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

  • Create New...