mysql distinct error

[taith]

when i take the id out, it works perfectly, but i need both of those columns, i need distinct path, and all id's associated with it.
[code]
$result=mysql_query("SELECT DISTINCT path, id FROM im_files WHERE (`uid1`='$id' AND `uid2`='$key') OR (`uid2`='$id' AND `uid1`='$key') ORDER BY id") or die(mysql_error());
[/code]

[Round]

i'm assuming that as you are using distinct on path you are only retrieving 1 corresponding id record?

[taith]

exactly, when i use distinct with path alone, it gives me one record... when i use it with id, it gives me all of them.

[Round]

I might be wrong but when you use distinct in this context should you not use group by too?

$result=mysql_query("SELECT DISTINCT path, id FROM im_files WHERE (`uid1`='$id' AND `uid2`='$key') OR (`uid2`='$id' AND `uid1`='$key') group by path") or die(mysql_error());

[taith]

perfect :-) thanks :-D