query problem

[adunphy]

I need help figuring out the logic on this one.

I have a table of scores for tests:
ID test1 test2 test3 test4 test5 etc

I need to calculate rankings for each person listed, for each test and then print the overall rankings. No test has more weight than another. Surely it can't be that hard, but for some reason I am blocked! Thanks for any help on this.

[devinemke]

<?php
$result = mysql_query('SELECT * FROM test_scores');
while ($row = mysql_fetch_assoc($result))
{
	$test1[$row['ID']] = $row['test1'];
	$test2[$row['ID']] = $row['test2'];
	$test3[$row['ID']] = $row['test3'];
	$test4[$row['ID']] = $row['test4'];
	$test5[$row['ID']] = $row['test5'];
}

arsort($test1);
arsort($test2);
arsort($test3);
arsort($test4);
arsort($test5);

echo 'the rankings for test 1 (highest to lowest):<br><br>';
foreach ($test1 as $key => $value)
{
	echo 'ID#: ' . $key . ' score: ' . $value . '<br>';
}

// repeat as necessary for other tests...
?>