List:General Discussion« Previous MessageNext Message »
From:Duncan Hill Date:December 29 2006 2:57pm
Subject:Re: Count the number of specific rows
View as plain text  
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.....
-- 
Scanned by iCritical.
Thread
Count the number of specific rowsServers24 Network29 Dec
  • Re: Count the number of specific rowsDuncan Hill29 Dec
  • Re: Count the number of specific rowsPhilip Mather29 Dec
  • Re: Count the number of specific rowsPeter Brawley29 Dec
Re: Count the number of specific rowsPhilip Mather29 Dec