Re: DISTINCT and multiple results...
| From: | Tyler Replogle | Date: | Mon, 07 Jun 2004 16:31:55 +0000 |
| Subject: | Re: DISTINCT and multiple results... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34671@lists.php.net to get a copy of this message | ||
hey,
you could do something like this
<?php $query = "SELECT * FROM
table Group by email";
$query_count++;
$result = mysql_query ($query);
while ($row = mysql_fetch_assoc ($result)) {
$title = $row["title"];
$first_name= $row["first name"];
$company = $row["company"];
echo"title: $title <br> first_name: $first_name <br> company: $company";
}
?>
From: Tristan.Pretty@risk.sungard.com To: Jonathan Haddad <jhaddad@superwebstuff.com> CC: php-db@lists.php.net Subject: Re: [PHP-DB] DISTINCT and multiple results... Date: Mon, 7 Jun 2004 14:05:41 +0100 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php_________________________________________________________________ Get fast, reliable Internet access with MSN 9 Dial-up now 3 months FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/