Re: DISTINCT and multiple results...

Ah, but then how can I select other info from the same table (title, first name, company etc...) Jonathan Haddad <jhaddad@superwebstuff.com> 07/06/2004 13:39 To Tristan.Pretty@risk.sungard.com cc php-db@lists.php.net Subject Re: [PHP-DB] DISTINCT and multiple results... select distinct email, username from table On Jun 7, 2004, at 8:19 AM, Tristan.Pretty@risk.sungard.com wrote: > Hi there... > I'm trying to create a MYSQL query that does the following... > > I've a table that lists ALL downloads from our site. > so I may have the same user many times, but different files, or infact, > same user, same file. > What my boss wants to see is: > If a user downloaded a file 3 times, she doesn't care, she just wants > to > see that it was downloaded. > So I tried using DISTINCT(email), but then I loose the data about the > other files that they've downloaded > How can I create a query, where I can list only one instance of email, > per > multiple instatnces of a file name. > > Does that make sence? > I'm reallyu stumped... > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- Jonathan Haddad jhaddad@superwebstuff.com http://www.superwebstuff.com