Drop down menu using order by option

[Anon]

I am trying to create a form that uses a field called Types of Businesses to populate a drop down menu.
The Table has multiple entries of Businesses and each one has a business type field which there may be multiple business that are Realtors or what ever. How can I eliminate all the duplicates
in the drop down menu?

I am using mssql. Thanks in advance for any help

[Anon]

if there are several business types in one field, then you are in for some serious coding, but if there are just duplicates then you can just use DISTINCT

i.e. SELECT DISTINCT business_type from businesses

[Anon]

Sorry, If I wasn't clear. I am new to this. Also, Thank you so much because it worked.

[Anon]

How you make drop down menu IN php fetching data from table.

Thanks

Vic