summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorarun <arun@nubati.net>2007-01-12 10:49:29 +0000
committerarun <arun>2007-01-12 10:49:29 +0000
commit88aaf2c34d0b3cc7eff994955a144a8d27b67c7a (patch)
tree905719aa44a22f7bdf076c77f2675cbc01aa1dbf
parent68e916d4e488f110dcdab69d7827e8b2f4129cd4 (diff)
downloade-DoKo-88aaf2c34d0b3cc7eff994955a144a8d27b67c7a.tar.gz
e-DoKo-88aaf2c34d0b3cc7eff994955a144a8d27b67c7a.tar.bz2
e-DoKo-88aaf2c34d0b3cc7eff994955a144a8d27b67c7a.zip
small bug in displaying the score
-rw-r--r--index.php2
1 files changed, 2 insertions, 0 deletions
diff --git a/index.php b/index.php
index e25b720..605a94b 100644
--- a/index.php
+++ b/index.php
@@ -526,6 +526,7 @@ else if(myisset("me"))
$result = mysql_query("SELECT fullname, SUM(score) FROM Score".
" LEFT JOIN Hand ON Hand.id=hand_id".
" LEFT JOIN User ON Hand.user_id=User.id".
+ " WHERE Hand.game_id=$gameid".
" GROUP BY fullname" );
$message = "The game is over. Thanks for playing :)\n";
while( $r = mysql_fetch_array($result,MYSQL_NUM))
@@ -647,6 +648,7 @@ else if(myisset("me"))
$result = mysql_query("SELECT fullname, SUM(score) FROM Score".
" LEFT JOIN Hand ON Hand.id=hand_id".
" LEFT JOIN User ON Hand.user_id=User.id".
+ " WHERE Hand.game_id=$gameid".
" GROUP BY fullname" );
while( $r = mysql_fetch_array($result,MYSQL_NUM))
echo " FINAL SCORE: ".$r[0]." ".$r[1]."<br />";