Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DUPLICATE FIELDS IN DROPDOWN LIST

Status
Not open for further replies.

kingjjx

Programmer
Joined
Sep 18, 2001
Messages
181
Location
US
Hi, I have a dropdown box. The choices are directly queried from a database table, particularly a column called MAKE.
Make has some duplicate entries since a make of a car could have many models so example would be HONDA repeating itselft in the MAKE column since it has different models (CIVIC, ACCORD, etc)

Is there anyway that I can just show Honda once in my dropdown list ? Right now, when you pull down the list it will show honda 5 times since there are 5 different models for it.

To get a better idea ... My testpage can be seen at:

thanks
 
Did you try selecting 'distinct make' in your query?
 
hey, how do i do that ?
 
hey, finally figured it out. thanks anyways.
i just used group="Make"

s-)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top