I have a query that populates a drop down, but I need only unique values. The link is at the bottom of the post.
I need to only show unique makes, but I don't know how to do the join. I've done joins before, but never with MySQL/PHP.
I'm hoping it's just something I'm missing.
FROM `lzakoor`.`makes`, `lzakoor`.`models`
INNER JOIN (SELECT DISTINCT makes.make_id
FROM `lzakoor`.`makes`) as makes
WHERE to_year >=1971
AND from_year <=1971;