Re: [PHP-DB] MySQL query, using DISTINCT...

2004-07-06 Thread Jason Wong
On Tuesday 06 July 2004 17:58, [EMAIL PROTECTED] wrote: > I have a system that tracks downloads, capturing loadsa info, but of > interest here, is email and filename. > Simply put, I wanna show all results where file name AND email are unique. > (so if email '[EMAIL PROTECTED]' has filename 'word.d

[PHP-DB] MySQL query, using DISTINCT...

2004-07-06 Thread Tristan . Pretty
I have a system that tracks downloads, capturing loadsa info, but of interest here, is email and filename. Simply put, I wanna show all results where file name AND email are unique. (so if email '[EMAIL PROTECTED]' has filename 'word.doc' 5 times in a table, I want to only see it once.) What am