Adding up results

[William Dalladay-Elliott]

Okay, I have a table with user results from a questionnaire... each row is the user id, question id and number of points from each question.

I want to be able to add up the points of each row (theres 20 questions in total)... whatever method I've tried has failed so far... my current "debug" function is:

function getResults($aID)
{
for($i = 1; $i <= 20; $i++) {
$sql = "SELECT rAID FROM qResults WHERE rUID = ". $aID ." AND rQID = ". $i;
$q = mysql_query($sql,$this->getConnection());
$r = mysql_fetch_array($q);

$p[$i] = $r["rAID"];
}

return $p[1] ." ". $p[2] ." ". $p[3] ." ". $p[4] ." ". $p[5] ." ". $p[6] ." ". $p[7] ." ". $p[8] ." ". $p[9] ." ". $p[10] ." ". $p[11] ." ". $p[12] ." ". $p[13] ." ". $p[14] ." ". $p[15] ." ". $p[16] ." ". $p[17] ." ". $p[18] ." ". $p[19] ." ". $p[20];
}
}

Any help would be much appreciated :)

~ Willmo