Re: Count the number of specific rows - Duncan Hill - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRe: Count the number of specific rows

From	Sent On	Attachments
Servers24 Network	29 Dec 2006 06:02
Duncan Hill	29 Dec 2006 06:57
Philip Mather	29 Dec 2006 07:07
Peter Brawley	29 Dec 2006 07:21
Philip Mather	29 Dec 2006 08:44

Subject:	Re: Count the number of specific rows
From:	Duncan Hill (dunc...@icritical.com)
Date:	12/29/2006 06:57:18 AM
List:	com.mysql.lists.mysql

On Friday 29 December 2006 14:02, Servers24 Network wrote:

Hi,

Well this question may seem funny, but I really need to know! The problem is with counting a user's contribution in my site. Suppose that each user that send an email will be stored in DB. Now I want to count number of times that a user has sent an email. I can simply use this : SELECT id FROM sent WHERE member_id= ... and the use count($result) to count the number, but I want a faster way, if possible.

select count(id) from sent.....