for($count=0;$count<$num_rows;$count++){

$player_id=mysql_result($result,$count,"players.player_id");
$name=mysql_result($result,$count,"name");
$army=mysql_result($result,$count,"army");
$beastmen=mysql_result($result,$count,"beastmen");
$dark_elves=mysql_result($result,$count,"dark_elves");
$dogs_of_war=mysql_result($result,$count,"dogs_of_war");
$dwarves=mysql_result($result,$count,"dwarves");
$empire=mysql_result($result,$count,"empire");
$goblins=mysql_result($result,$count,"goblins");
$high_elves=mysql_result($result,$count,"high_elves");
$chaos=mysql_result($result,$count,"chaos");
$lizardmen=mysql_result($result,$count,"lizardmen");
$ogre=mysql_result($result,$count,"ogre");
$skaven=mysql_result($result,$count,"skaven");
$tomb_kings=mysql_result($result,$count,"tomb_kings");
$vampire_counts=mysql_result($result,$count,"vampire_counts");
$wood_elves=mysql_result($result,$count,"wood_elves");

function convert($value) {

	if ($value=="M") $points=4;
	else if ($value=="SV") $points=3;
	else if ($value=="MV") $points=2;
	else if ($value=="D") $points=1;
	else $points=0;
	
	return $points;
}

$beastmen_pts=convert($beastmen);
$dark_elves_pts=convert($dark_elves);
$dogs_of_war_pts=convert($dogs_of_war);
$dwarves_pts=convert($dwarves);
$empire_pts=convert($empire);
$goblins_pts=convert($goblins);
$high_elves_pts=convert($high_elves);
$chaos_pts=convert($chaos);
$lizardmen_pts=convert($lizardmen);
$ogre_pts=convert($ogre);
$skaven_pts=convert($skaven);
$tomb_kings_pts=convert($tomb_kings);
$vampire_counts_pts=convert($vampire_counts);
$wood_elves_pts=convert($wood_elves);

$total=$beastmen_pts+$goblins_pts+$dark_elves_pts+$dogs_of_war_pts+$dwarves_pts+$empire_pts+$high_elves_pts+$chaos_pts+$lizardmen_pts+$ogre_pts+$skaven_pts+$tomb_kings_pts+$vampire_counts_pts+$wood_elves_pts;