Hi,

 using "group by" can also be usefull.

zareef ahmed  

--- Torsten Roehr <[EMAIL PROTECTED]> wrote:
> "Tristan Pretty" <[EMAIL PROTECTED]>
> wrote in message
>
news:[EMAIL PROTECTED]
> com...
> > 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 I doing wrong...?
> >
> > SELECT DISTINCT(file_name, email) FROM
> `completed_downloads` WHERE `bu`  =
> >  'reech' AND date BETWEEN '2004-06-01' AND
> '2004-06-30'
> >
> > Tris...
> 
> Hi Tristan,
> 
> I'm not an MySQL expert but DISTINCT removes
> duplicate *rows* from your
> result set. As you select email AND file_name you
> will always have a unique
> row (combination of email and file_name). Try
> without specifying file_name:
> 
> SELECT DISTINCT email FROM `completed_downloads`
> WHERE `bu` = 'reech' AND
> date BETWEEN '2004-06-01' AND '2004-06-30'
> 
> Regards, Torsten Roehr
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 


=====
Zareef Ahmed :: A PHP Developer in Delhi(India).
Homepage :: http://www.zasaifi.com


                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to