[RESOLVED] SQL query syntax

[turtleton09]

Hope someone can help with this.

I have a database structure :

table : photos (Photo_ID (PK), Title, Supplier etc)
table : keywords (Keyword_ID, Keyword, Category)
table : photokeywords (Photo_ID, Keyword_ID)

I have a search form that I'm using where users can check a checkbox for any number of keywords to find all photos with any of those keywords assigned to it.

My results page has the following SQL as it's query :

SELECT *
FROM photos INNER JOIN photokeywords ON photos.Photo_ID = photokeywords.Photo_ID

What I want to disply is one result for each photo, regardless of how many matching keywords are found, but what this is doing is displaying one record for each matching keyword, ie if a Photo_ID has three of the selected keywords, I'm getting three records displayed for that photo - one for each matching keyword.

What should it be just to display a unique record for each photo?

[Piranha]

I believe that you haven't put your whole query here since that query will get all photos that have one or more keywords.

Anyway, to solve your problem you can use "GROUP BY photos.Photo_ID".

[turtleton09]

Thank you! There was more code that was doing the filtering, which was working insomuch as I was getting the right photos, just with a record for each matching keyword - so I figured the issue was with the SELECT query.

I tried DISTINCT, but that didn't help, but GROUP BY is working nicely.