DISTINCT and multiple results...
| From: | Tristan dot Pretty at risk dot sungard dot com | Date: | Mon, 07 Jun 2004 12:19:54 +0000 |
| Subject: | DISTINCT and multiple results... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34666@lists.php.net to get a copy of this message | ||
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...