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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
