DISTINCT SELECT

[Anon]

$result2 = mysql_query("SELECT DISTINCT customers.directoryIDone, customers.directoryIDtwo, customers.countyID, counties.countiesID, counties.countiesName FROM customers, counties WHERE ((customers.directoryIDone = '$id') OR (customers.directoryIDtwo = '$id')) AND counties.countiesID = customers.countyID ORDER BY counties.countiesName LIMIT $count,$limit");

Pulls out the following:

Cheshire
Devon
Dorset
Hertfordshire
Isle of Wight
London
London
London
Oxfordshire
Staffordshire
Surrey
West Midlands
Wiltshire
Wiltshire

Question is, why am i getting duplicate results?

[Anon]

Try using a different type of join in you query... sometimes a default join type will not work you may have to be more specific with INNER or OUTER JOINS.
It is hard for me to right it as I don't know much about the database.

[Anon]

try your SQL statement with a
(GROUP BY) statement :

$result2 = mysql_query("SELECT DISTINCT
customers.directoryIDone, customers.directoryIDtwo,
customers.countyID,
counties.countiesID,
counties.countiesName
FROM customers, counties
WHERE ((customers.directoryIDone = '$id') OR (customers.directoryIDtwo = '$id')) AND counties.countiesID = customers.countyID
GROUP BY counties.countiesName
ORDER BY counties.countiesName LIMIT $count,$limit");

---you might have to GROUP BY all of your returned fields.....I know Oracle won't like the GROUP BY statement unless yougroup by each field your select....
Hope this helps...

[Anon]

usually when I use distinct (mysql) I specify a field.

SELECT DISTINCT(country) FROM table