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: [EMAIL PROTECTED]
To: Jonathan Haddad <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
07/06/2004 13:39

To
[EMAIL PROTECTED]
cc
[EMAIL PROTECTED]
Subject
Re: [PHP-DB] DISTINCT and multiple results...






select distinct email, username from table

On Jun 7, 2004, at 8:19 AM, [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
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/


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



Reply via email to