Re: Count total
| From: | Rasmus Lerdorf | Date: | Sun, 19 Aug 2001 09:50:57 +0000 |
| Subject: | Re: Count total | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-63378@lists.php.net to get a copy of this message | ||
On Sun, 19 Aug 2001, Martin Kampherbeek wrote:
> Hi,
>
> Who can help me with the following problem?
> I have the tables score and totalscore.
>
> Score:
> id
> userid
> name
> score
>
> Totalscore:
> userid
> name
> totalscore
>
> In the table score one user can have mutiple scores. But in totalscore
> the userid is unique. Now I want to count all the score's of a user en
> place this at the same user in totalscore.
>
> Example of score:
> 1 1 Martin 10
> 2 2 John 5
> 3 3 Richard 12
> 4 1 Martin 3
> 5 3 Richard 8
> 6 1 Martin 7
> 7 2 John 15
>
> So I would like to know the total score of each user.
> But I don't know how to do this. Who can help me out?
insert into totalscores (userid,name,totalscore) select userid, name, sum(score) as totalscore from
scores group by userid;
-Rasmus