Codezwiz >> Forums >> General PHP Nuke Help >> Loop issue

The code below produces multiple lists and I need it to produce only one list with the scores added. Do I break out of the loop or is there some way to do this?

$result = mysql_query("select quizzId, quizzTitle, active, restrict_user, administrator,displayscore,nbscore from ${prefix}_quizz_admin where cid='$cid' order by timeStamp desc");
while(list($qid, $quizzTitle,$active,$restrict_user,$administrator,$displayscore,$nbscore) = mysql_fetch_row($result))
{
         # display the inactive quizz if admin
         if (is_admin($admin) or ($administrator != "" and $cookie[1] == $administrator))
         {
            print "<tr><td>";

               if ($displayscore)
               {
            $ress = mysql_query("SELECT username, SUM(score) as Total_score FROM ${prefix}_quizz_check group by username ORDER BY Total_score DESC,time DESC LIMIT $nbscore ");

               if (mysql_num_rows($ress)>0)
               {
               echo "";
            while(list($username,$res) = mysql_fetch_row($ress))
               {
               print "<tr><td><font class=catdesc>$username ;; ;;</td><td><div align=right>$res</div></td></tr></font>";
               }