Hi,
I've got a query to list and print all the items in my shop, but now I want list only those from two categories.
I add the two last lines to the query, and it crashes. It seems there are two many items to list, and I think mysql is making combination with all the items in category 65 with the rest of the query (because if I delete the last line all runs fine)
Any suggestions?
Thanks,
Arbocenc
SELECT products.products_id, categories_name, products_name, products_price, manufacturers_name, products_weight
FROM products, products_description, categories_description, products_to_categories, manufacturers
WHERE products.products_id = products_to_categories.products_id
AND products_to_categories.categories_id = categories_description.categories_id
AND products.products_id = products_description.products_id
AND products.manufacturers_id = manufacturers.manufacturers_id
AND products_status='1'
AND products_description.language_id='4'
AND categories_description.language_id='4'
AND categories_description.categories_id='64'
[b]OR categories_description.categories_id='65'[/b]
[/b]