SELECT DISTINCT products.id,products.image,products.name, products.description,products.id,products.price FROM products,subcat,deepcat,maincat WHERE (products.main_cat=13 AND maincat.id=13)
it's only part of the query but i have a record in products where main_cat is equal to 13 and there is a maincat.id equal to 13 as well.why is it returning an empty set? i'm on mysql 4.0.x
yeah.may be the worst performance wise but shouldn't affect the results. it was working on my old server.moved it to 1&1 and now it won't work. here's the entire query
SELECT DISTINCT products.id,products.image,products.name, products.description,products.price FROM products,subcat,deepcat,maincat WHERE (products.main_cat=13 AND maincat.id=13) OR (subcat.maincat_id=13 AND products.sub_cat=subcat.id) OR (subcat.maincat_id=13 AND deepcat.subcat_id=subcat.id AND products.deep_cat=deepcat.id)