I am working on building a dynamic menu that searches the database for the manufacturer ID to get the product catagories for the submenu. The problem that I am having right now is that when searching the Products table, there are multiple entries from the same manufacturer thus showing multiple instances of the same manufacturer in the menu. What I am trying to do is search the Products database table and get all of the Manufacturer IDs then pull out just one of each instead of ALL of them since there are multiples of each. Any and all help is GREATLY appreciated.
Comment