Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

whats wrong with this MySQL database_query?


Guest

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.

 

thanks

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.

 

HTH,

-Chris

Chris Sullivan

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...