On Jun 17, 11:45 pm, subtenante <zzsubtenant...@gmail.com> wrote:
> On Mon, 18 Jun 2007 17:39:28 +0800, subtenante
>
> <zzsubtenant...@gmail.com> wrote:
> >SELECT SUM(score) INTO _res
> >FROM (
> > SELECT r2.score AS FROM results r2
> > WHERE r2.division=_division AND r2.name=_name
> > ORDER BY r2.score DESC LIMIT 5
> >) AS tmptable;
>
> I was right i made some mistakes ! Corrected.


Thank you for ALL your help. How can this be accomplished NOT using a
FUNCTION? My ISP does not allow FUNCTIONS on MySQL for security
reasons (not sure why thats an issue) but none the less, I appreciate
any insite to your solution without functions.

Here is a test environment setup. See if this can be done with TOP 3
just for brevity sake:

DROP TABLE games;
CREATE TABLE games (
pkey int(11) NOT NULL auto_increment,
division varchar(15),
user varchar(15),
payout int,
PRIMARY KEY (pkey)
);

INSERT INTO games (division, user, payout) VALUES ('A','fred',11);
INSERT INTO games (division, user, payout) VALUES ('A','fred',2);
INSERT INTO games (division, user, payout) VALUES ('A','fred',13);
INSERT INTO games (division, user, payout) VALUES ('A','fred',4);
INSERT INTO games (division, user, payout) VALUES ('A','fred',5);
INSERT INTO games (division, user, payout) VALUES ('A','matt',1);
INSERT INTO games (division, user, payout) VALUES ('A','matt',21);
INSERT INTO games (division, user, payout) VALUES ('A','matt',31);
INSERT INTO games (division, user, payout) VALUES ('A','matt',14);
INSERT INTO games (division, user, payout) VALUES ('A','matt',5);
INSERT INTO games (division, user, payout) VALUES ('B','tom',13);
INSERT INTO games (division, user, payout) VALUES ('B','tom',20);
INSERT INTO games (division, user, payout) VALUES ('B','tom',23);
INSERT INTO games (division, user, payout) VALUES ('B','tom',9);
INSERT INTO games (division, user, payout) VALUES ('A','tom',15);
INSERT INTO games (division, user, payout) VALUES ('B','rick',18);
INSERT INTO games (division, user, payout) VALUES ('B','rick',29);
INSERT INTO games (division, user, payout) VALUES ('B','rick',21);
INSERT INTO games (division, user, payout) VALUES ('B','rick',8);
INSERT INTO games (division, user, payout) VALUES ('B','rick',25);

Thanks again!!