<?php

 
 
 
 mysql_connect("localhost", "root", "");
 mysql_select_db("***");
 
 
 $q  = " SELECT * FROM vysledky WHERE  id_souteze = 1 AND schvaleno = 2 ";
 $mq = mysql_query($q);
 
 $tym = array();
 
 
 $tymyID = array(38, 33, 35, 37, 34, 36, 39);
 $polozky = array("zapasy", "v", "r", "p", "gf", "ga");
 
 foreach ($polozky as $A)
  {
   foreach ($tymyID as $B)
    {
     $tym[$A][$B] = 0;
    }
  }
 
 
 while ($r = mysql_fetch_object($mq))
  {
      $tym['ID'][$r->d_tym] = $r->d_tym;
    
    // vyhra domaciho
    if ($r->d_goly > $r->h_goly)
     {
      $tym['zapasy'][$r->d_tym]++;
      $tym['v'][$r->d_tym]++;
      $tym['gf'][$r->d_tym] += $r->d_goly;
      $tym['ga'][$r->d_tym] += $r->h_goly;
     }
     
    // remiza  domaciho
    elseif ($r->d_goly == $r->h_goly)
     {
      $tym['zapasy'][$r->d_tym]++;
      $tym['r'][$r->d_tym]++;
      $tym['gf'][$r->d_tym] += $r->d_goly;
      $tym['ga'][$r->d_tym] += $r->h_goly;
     } 
     
    // prohra  domaciho
    elseif ($r->d_goly < $r->h_goly)
     {
      $tym['zapasy'][$r->d_tym]++;
      $tym['p'][$r->d_tym]++;
      $tym['gf'][$r->d_tym] += $r->d_goly;
      $tym['ga'][$r->d_tym] += $r->h_goly;
     }
     
  }
 
 
 
 
 $q  = " SELECT * FROM vysledky WHERE  id_souteze = 1 AND schvaleno = 2 ";
 $mq = mysql_query($q);
 

 
 while ($r = mysql_fetch_object($mq))
  {
    
    $tym['ID'][$r->h_tym] = $r->h_tym;
    
    // vyhra hosta
    if ($r->d_goly < $r->h_goly)
     {
      $tym['zapasy'][$r->h_tym]++;
      $tym['v'][$r->h_tym]++;
      $tym['gf'][$r->h_tym] += $r->h_goly;
      $tym['ga'][$r->h_tym] += $r->d_goly;
     }
     
    // remiza  hosta
    elseif ($r->d_goly == $r->h_goly)
     {
      $tym['zapasy'][$r->h_tym]++;
      $tym['r'][$r->h_tym]++;
      $tym['gf'][$r->h_tym] += $r->h_goly;
      $tym['ga'][$r->h_tym] += $r->d_goly;
     } 
     
    // prohra hosta
    elseif ($r->d_goly > $r->h_goly)
     {
      $tym['zapasy'][$r->h_tym]++;
      $tym['p'][$r->h_tym]++;
      $tym['gf'][$r->h_tym] += $r->h_goly;
      $tym['ga'][$r->h_tym] += $r->d_goly;
     }
     
  }
 
 print_r($tym);
 
 ksort($tym);
 array_multisort ($tym[v], SORT_DESC, SORT_NUMERIC); 

 echo "<table border=1 style='width: 400px;'>";
 echo "<tr>";
   echo "<th>ID</th>";
   echo "<th>Z</th>";
   echo "<th>V</th>";
   echo "<th>R</th>";
   echo "<th>P</th>";
   echo "<th>GF</th>";
   echo "<th>GA</th>";
 echo "</tr>"; 
 
 
 foreach ($tym['zapasy'] as $key => $value )
  {
   echo "<tr>";
     echo "<td>".$tym['ID'][$key]."</td>";
     echo "<td>".$tym['zapasy'][$key]."</td>";
     echo "<td>".$tym['v'][$key]."</td>";
     echo "<td>".$tym['r'][$key]."</td>";
     echo "<td>".$tym['p'][$key]."</td>";
     echo "<td>".$tym['gf'][$key]."</td>";
     echo "<td>".$tym['ga'][$key]."</td>";
     
   echo "</tr>";
  }
 
 echo "</table>";
 
 /*
 echo "<pre>"; 
 print_r($tym);
 echo "</pre>";
*/ 
 
 
 
 
 
 
 
?>