Codezwiz >> Forums >> General PHP Nuke Help >> Quiz Module

I am using the "Quizz" module by xbee for phpnuke. It displays a ranking for each quiz within a subject using the code below and I would like to have a combined ranking so each time a member completes a new quiz the combined ranking will increase instead of having a bunch of seperate rankings. A new row is created each time the user completes a quiz with the table cells

ip time username email qid score answers

Thank you

code:
if ($displayscore)
{
$ress = mysql_query("SELECT username, score FROM ${prefix}_quizz_check WHERE qid='$qid' ORDER BY score DESC,time DESC LIMIT $nbscore ");
print " ";
if (mysql_num_rows($ress)>0)
{
echo ""._QUIZZLISTSCORE.": ";
while(list($username,$res) = mysql_fetch_row($ress))
{
print "$username : $res ";
}
print " ";
}
}