Member Avatar for virusisfound

Hi,

I am working on one inventory control project in that I have one combo box in the combo box I am showing all the product name but in database their is duplication of product name when user sale one product then it save in the table. So the user sale one product for 3 times then it displays three time name in the combo box. I want to show only once time product name.

Is their is any solution for this problem.

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Use SELECT DISTINCT clause.

SELECT DISTINCT ProductName FROM TABLE

Or - use GROUP BY.

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.