dachshund Posted December 9, 2011 Share Posted December 9, 2011 I'm building a shopping site with various section - men's, women's, accessories etc. What I need to do is find what brands are available in each section. In the datatbase the item has item id, title, brand, price, section etc. So I need something like SELECT brand FROM store WHERE id LIKE $id AND section LIKE $section That will select all the brands, but then I need to condense those down and find any duplicates. Any help would be amazing. Thanks Link to comment https://forums.phpfreaks.com/topic/252819-select-brand-column-and-removecondense-duplicates/ Share on other sites More sharing options...
Pikachu2000 Posted December 9, 2011 Share Posted December 9, 2011 SELECT DISTINCT field FROM table WHERE . . . Link to comment https://forums.phpfreaks.com/topic/252819-select-brand-column-and-removecondense-duplicates/#findComment-1296189 Share on other sites More sharing options...
dachshund Posted December 9, 2011 Author Share Posted December 9, 2011 thanks Link to comment https://forums.phpfreaks.com/topic/252819-select-brand-column-and-removecondense-duplicates/#findComment-1296253 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.