Re: MySQL query, using DISTINCT...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tuesday 06 July 2004 17:58, Tristan.Pretty@xxxxxxxxxxxxxxxx wrote:
> 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 '123@xxxxxxxxxxx' has filename 'word.doc' 5 times in a table,
> I want to only see it once.)
>
> What am I doing wrong...?

Well what did you expect your code to do when you run it, and what is it 
actually doing?

Please spend a little time describing your problem clearly and succintly when 
posting.

In the absence of more information, my guess is that your biggest problem is 
that you're not doing sufficient error checking in your code.

AFAICS ...

> SELECT DISTINCT(file_name, email) FROM `completed_downloads` WHERE `bu`  =
>  'reech' AND date BETWEEN '2004-06-01' AND '2004-06-30'

would give a mysql error. The correct syntax is:

  SELECT DISTINCT col1, col2, etc FROM table ...


Please follow the examples in the manual and incorporate error checking when 
using mysql.

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
Nondeterminism means never having to say you are wrong.
*/

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux