Re: SUM problem.
Hmm... interesting... but that solution is made for 1 user with 10 scores.
However, now it's way over 100 users....
Is there any way you can put it into one select to actually "scroll" through all users, and sort it with that solution ?
Well, to show my current SELECT.
SELECT
lepok_user.id AS userid,
firstname,
lastname,
type,
lepok_torney.id,
date,
YEAR(date),
YEAR(CURRENT_DATE()),
SUM(points),
MAX(points),
user,
torney
FROM
lepok_user,
lepok_result,
lepok_torney
WHERE
lepok_user.id=user
AND
typ='$pligan'
AND
lepok_torney.id=torney
AND
YEAR(date)=YEAR(CURRENT_DATE())
GROUP BY
lepok_user.id
ORDER BY
SUM(points) DESC,
MAX(points) DESC
(I translated the names of the variables as I use swedish variable names and not english, so I might have made a type here in this code where I forgot a letter somewhere, but I hope you get the picture)
Edited 2 time(s). Last edit at 03/13/2009 07:33PM by Patric Andersson.