[colicab-d]

why not fetch the scores by user id as you doing, but then have a bit of code like where the id matches the userid add the 4 scores together...

simple maths.. or am i missing something as usual lol

or let me guess thast what u wana know

try this :

PHP Code:

    while($r1 = mysql_fetch_array($total)){

    $score1=$r1['score1'];
    
    $score2=$r1['score2'];

    $score3=$r1['score3'];

    $score4=$r1['score4'];
    
$subtotal1 = $score1 + $score2 ;
$subtotal2 = $subtotal1 + $score3 ;
$finaltotal = $subtotal2 + $score4 ;

}