montana Posted October 6, 2006 Posted October 6, 2006 (edited) Is there someone here that could fix this? The error is in all my categories. Just showed up a few days ago............have no idea how to fix it. I would be glad to pay someone of course. Judy 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '21' [TEP STOP] Edited October 6, 2006 by montana Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.