I'm creating a search page and on it people can search by brand. They can do this by toggling a SELECT OPTION
What I am wanting to do is make these OPTIONS dynamic and only include brands that I will actually be carrying.
Is there a way to do a lookup on a MySQL table of products and for each different type of data, to generate a <OPTION></OPTION> option for it?
Like.. a foreach different type of data. The thing I am having a problem with is that there are several different types of products of the same category, such as 'product 1' and 'product 4' both being T-Shirt's, I don't want to have two options as <OPTION>T-Shirt</OPTION><OPTION>T-Shirt</OPTION>.
Can what I want to do even be done??