Creating a User Ranking using Mysql

I have a database where users send out emails to various people

I would like to be able to rank the users based on how many email
each of them have sent out

My table looks similar to thi

sent_to sent_by type_sen

sent_to - who they sent the email t
sent_by - the user name of the sende
type_sent - support question type

I would like to know what type of php query I can send to the databas
that would tell me how many emails each user has sent

On Fri, 18 Nov 2005 11:40:07 -0600, Ace wrote:
> I have a database where users send out emails to various people.
>
> I would like to be able to rank the users based on how many emails each of
> them have sent out.
>
> My table looks similar to this
>
> sent_to sent_by type_sent
>
> sent_to - who they sent the email to
> sent_by - the user name of the sender type_sent - support question type
>
> I would like to know what type of php query I can send to the database
> that would tell me how many emails each user has sent.

The MySQL query would be:

SELECT COUNT(*) AS count, sent_by FROM MyTable GROUP BY sent_by

You can use it in PHP's mysql_query (or whatever database abstraction you
use) in the normal way.

Cheers,


--
Andy Jeffries | gPHPEdit Lead Developer
http://www.gphpedit.org | PHP editor for Gnome 2
http://www.andyjeffries.co.uk | Personal site and photos