Seperate Out Repeats on SQL Join

[kulmu]

Ok so I have my join working and am attempting to filter out any duplicates of a single column. I don't even know where to start for this. Basically on the join I want to check for any duplicates of the 'PropID' column and only post one copy of the PropID onto my webpage.

What's the best method to accomplish this?

[r937]

What's the best method to accomplish this?

you might start by showing us your query, and sample results of what it currently produces as well as what you would like it to produce

[kulmu]

SELECT 
a.PropID, a.PropName, a.LargeDogs, b.Size 
FROM properties 
AS a INNER JOIN 
floorplans AS b 
ON b.PropID = a.PropID 
WHERE a.Active = '1' 
AND b.Size LIKE '2BD%'
ORDER BY a.PropID LIMIT 30

I am getting duplicates from communities that have multiple floorplans on the same options. So Instead of showing PlanID 3 times when it loops I would like it to skip the duplicates and only display each PropID once, instead of 3 or 4 times as it can do now.

[r937]

gee, a different thread, but i'm sure i've seen that query before

what would you like to show along with each unique PropID?

obvioulsy if each property has multiple floorplans with sizes like '2BD%', then which size would you like to show?

[kulmu]

Yep just noticed it was you that replied. Other forum was the database one though and figured was best to move this over to the PHP forum.

Basically just need the PropID to be unique.

[r937]

so you don't need any sizes at all in the query results?

[kulmu]

Nope just need to know they do exist. Basically there will be a page that has some checkboxes to select options that will be searched for. This query was hopefully going to accomplish that.

[r937]

okay, do this:

SELECT DISTINCT
       a.PropID, a.PropName, a.LargeDogs
  FROM properties AS a 
INNER 
  JOIN floorplans AS b 
    ON b.PropID = a.PropID 
 WHERE a.Active = '1' 
   AND b.Size LIKE '2BD%'
ORDER 
    BY a.PropID LIMIT 30