Hi
SELECT
COUNT(DISTINCT trEmail ) as clicks
, trEmail FROM table
GROUP BY trEmail
ORDER BY clicks DESC
will probably give what you are looking for
Peter
-----Original Message-----
From: Tim Thorburn [mailto:[EMAIL PROTECTED]
Sent: 15 June 2003 00:14
To: [EMAIL PROTECTED]
Subject: selecting DISTINCT and COUNT in MySQL
Hi,
I'm setting up a small tracking program for a site I'm working on -
basically it monitors all external web and email links that are clicked
from our site and stores them into a MySQL database.
Now I'm trying to extract the information from the database and display it
on screen with PHP. I've made a query which reads:
SELECT DISTINCT trEmail FROM db-name;
This clearly selects all the distinct email addresses from my table, but I
would like to put a count beside each of the distinct addresses to show how
many times each link was clicked.
For example, I'd like it to look something like the following:
email address # sent
[EMAIL PROTECTED] 12
Meaning that the email addresses '[EMAIL PROTECTED]' was clicked a total of 12
times.
I'm thinking there should be a way to do this with a single SQL query ...
although after most of the day of trying and searching google - I've come
up with nothing but a headache.
Any thoughts?
Thanks
-Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
