dejaiman Posted October 11, 2007 Share Posted October 11, 2007 I have copied a product into 3 different categories. When a search has been carried out that retrieves that product, the results show the product three times. This should not be as it is the same product. Does this happen to anyone else, and can it be fixed? Link to comment Share on other sites More sharing options...
Gauravs Posted October 11, 2007 Share Posted October 11, 2007 Doesn't sound like bug, since the product is unique in each category, and thus listed once for each category. Best Regards,Gaurav Link to comment Share on other sites More sharing options...
dejaiman Posted October 11, 2007 Author Share Posted October 11, 2007 Any ideas to fix this though? Link to comment Share on other sites More sharing options...
Gauravs Posted October 11, 2007 Share Posted October 11, 2007 Any ideas to fix this though? USE DISTINCT in SQL QUERY to give only UNIQUE results when resultset has more then one identical results. ie, check code for query that is generating results in advanced_search, and modify it to include DISTINCT eg, if original query is "select a, b , c from table 1, ... " to get unique results you may modify as "Select distinct a, b, c from table 1, .... " That should do the trick for you, short of time to check query, give it a shot, and if i get time, would post the code here. Cheers Best Regards,Gaurav 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.