Add text to all product descriptions in a category
Hi,
What table joins can I use to find all products in a given category?
I initially thought that master_categories_id on the products table would be it, but when I query the table as
SELECT * FROM products_description where master_categories_id = 100
it throws the error
Error: Unknown column 'master_categories_id' in 'where clause'
SQLState: 42S22
ErrorCode: 1054
I know SQL but not a MySQL guy, so not sure how to use that column. Appreciate any tips!
My install: was Vanilla 1.3.9h, now 1.5.5b, Apache 2.4, PHP 7.0.6, MySQL 5.5.8 64b, Windows 7 64b, 8GB RAM, i3 3.3gHz
Modules: [Payment=Paypal] [Shipping=Canada Post 1.5.3 merged] [nonCAPTCHA]
Bookmarks