Page 1 of 1

How do I do this

Posted: Fri Jul 09, 2010 2:38 am
by bodycount
I am trying to run a 10 pin bowling league and I am trying to get a high score page for players and for teams. My problem is how do I get the high scores from three colums

|------------------| ------------------|------------------|
| Game 1 | Game 2 | Game 3 |
|------------------|-------------------|------------------|
200 190 150
191 170 201
189 180 175

I can do the following to get the highest score from each column individually

SELECT Game 1,PLAYERNAME FROM bowling.scores order by Game 1 desc;
result 200 player1 , 191 player2 , 189 player2

SELECT Game 2,PLAYERNAME FROM bowling.scores order by Game 2 desc;
result 190 player3 , 180 player1 , 170 player3

SELECT Game 3,PLAYERNAME FROM bowling.scores order by Game 3 desc;
result 201 player1 , 175 player1 , 150 player3

But what if the second highest score in Game 1 beats the highest score in Game 2. What do I do to sort this out?

Re: How do I do this

Posted: Fri Jul 09, 2010 8:14 am
by ScOrPi
Dear ,

u can always compare the results before inject it in database

just like

$query = "SELECT Game1 From Games";
$result = mysql_query($query);
$top = mysql_fetch_array($result);
$game1-first = $top['player1'];
$game1-second = $top['player2'];
$game1-third = $top['player3'];

now u'd saved the Top players for game 1 .. repeat for game2 and game3
then make conitions and start UPDATE the database ..

i hope that u'd understood me !

Re: How do I do this

Posted: Fri Jul 09, 2010 9:17 am
by mikosiko
I will simplify doing two rankings:
1) Ranking by Game and
2) Ranking for accumulated points... and I will use this last one as the only order criteria if I choose to simplify further.