$factionsys = $factionsysdet = $row = array();



$query = sprintf("SELECT id from systemes");

$result = mysql_query($query);



while($row = mysql_fetch_assoc($result)) {



$faction1 = $faction2 = $faction3 = $faction4 = 0;



$query22 = sprintf("SELECT faction_id from planetes WHERE faction_id IS NOT NULL and systeme_id = '%s'",

	mysql_real_escape_string($row['id']));

$result22 = mysql_query($query22);



while($row2 = mysql_fetch_assoc($result22)) {





switch ($row2['faction_id']) {

	case 1: $faction1 = $faction1 +1;

		break;

	case 2: $faction2 = $faction2 +1;

		break;

	case 3: $faction3 = $faction3 +1;

		break;

	case 4: $faction4 = $faction4 +1;

		break;

default:

break;

						} // fin switch







							} // fin while





$testfac = max($faction1,$faction2,$faction3,$faction4);

$row['finalfac']= $testfac;

if ($testfac != 0 && $testfac != NULL) {array_push($factionsys,$row);}

		} // fin while 2





foreach ($factionsys as $VAL) {

...$VAL...

}