<?
$x=0;
$g=0;
$p=0;
$id=0;
@require_once 'c.php';
@require_once 'mysql.php';
$z = mysql_query("SELECT * FROM `$config[mysql_config_table_1]` WHERE 1");
if($z===FALSE){die("Błąd  1");}
while ($o=mysql_fetch_array($z)) {
    $kol1=$config[mysql_config_kolumna_1];
    $g=0;
    $p=0;
    
        $z2=mysql_query("SELECT `$config[mysql_config_kolumna_2]` FROM `$config[mysql_config_table_2]` WHERE `$config[mysql_config_kolumna_1]`='$o[$kol1]'");
        if($z2===FALSE){die("Błąd 2");}
        while($o2=mysql_fetch_array($z2)){
            $kol2=$config[mysql_config_kolumna_2];
            $z3=mysql_query("SELECT `$config[mysql_config_kolumna_3]` FROM `$config[mysql_config_table_3]` WHERE `$config[mysql_config_kolumna_4]`='$o2[$kol2]'");
            if($z3===FALSE){die("Błąd 3");}
            $o3=mysql_fetch_array($z3);
            $kol3=$config[mysql_config_kolumna_3];
            
            $p=$p+$o3[$kol3];
            $g++;
        }
    
    
    
    $ng[$x]=$o[$kol1];
    $sg[$x]=$p/$g;
    $x++;
}
rsort($sg);
echo "<br>";
$x--;
for ($i=0; $i <=$x; $i++) {
    echo $ng[$i]." : ". $sg[$i]."<br>";
    
    
    
    
}