knifeman Posted April 14, 2011 Share Posted April 14, 2011 I have all my products in one category All products Then I have several more categories where products are copied to, via the link method. Blue products Red Products I have a couple of mods added like 'all products' and 'printable catalog'. Both mods show my products for every instance in each category instead of just once. In printable catalog mod they say add the term distinct into this query $print_catalog_query_raw = "select distinct p.products_id But it still shows duplicates. One for every category they are listed in. Have I inserted the term wrong? Or this there something else I need to add? Tim posted query is just a partial code, it goes on forever. Link to comment Share on other sites More sharing options...
knifeman Posted April 14, 2011 Author Share Posted April 14, 2011 been reading up on the distinct keyword. Apperently that keyword is for the entire query, not just the field immediately after it. So the entire query also calls in categories, making the same product look different. Hopefully I can find a way to either reduce my query(remove category results) or make distinct apply to one field. Tim Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.