Member Avatar for joseph.lyons.754

Hey guys

im populating a combo box from my database i was just wondering how do i prevent the combo box from displaying different instances of the same value. e.g three B&Bs all from ennis. ennis is in the combobox but its displayed three times.

how do i stop this ??

Thanks

  • 4 Contributors
  • 4 Replies
  • 148 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Szabi Zsoldos
Member Avatar for pritaeas

Show the query you use to retrieve the values (and some sample data would be helpful too).

Member Avatar for simplypixie

I agree with @pritaeas but off the top of my head, use DISTINCT in your query to only retrieve one instance of the same value.

Member Avatar for Szabi Zsoldos

You can use distinct or Group BY, either of that works.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.