Member Avatar for Orange-Mongoose

Hi there,

I have Page that goes to "sub categorys", but each time I upload a new product the subcategory gets duplicated each time, instead of having one "Vintage" category as I want I have duplicates.

My current SQL query string is

SELECT DISTINCT Picture, SubCategory, Categorie FROM Table1 WHERE (Categorie = ?)"

The distinct doesn't filter out duplicates.

  • 2 Contributors
  • 1 Reply
  • 60 Views
  • 22 Minutes Discussion Span
  • Latest Post Latest Post by JorgeM
Member Avatar for JorgeM

DISTINCT will remove duplicates, but only if the fields you select from are all duplicates.

You have three fields here. Look at the results...is the info in the three fields identical?

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.