コード例 #1
0
ファイル: teams.php プロジェクト: haverver/SVN
 
 <TABLE>
 <?
     //SELECT TEAMS
     $sql        = "SELECT * FROM svn_teams WHERE seizoen_id = ".$_SESSION['seizoen'];
     $result     = mysql_query($sql);
     if(mysql_num_rows($result) > 0)
     {
         echo "<TR>";
         for($a = 0; $a < mysql_num_rows($result); $a++)
         {
             $team = mysql_fetch_array($result);
             echo "<TD valign=\"top\"><TABLE><TR><TD colspan=3>".$team["naam"];
             ?>
             <form action="teams.php" method="post">
             <select name="speler_add"><?  $competitie->spelers_select(); ?></select>
             <input type="hidden" name="team" value="<? echo $team["id"]; ?>">
             <input type="submit" value="Toevoegen">
             </form>                   
             <?
             
             $sql2 = "SELECT * FROM svn_leden_teams WHERE team_id = ".$team["id"];
             $result2 = mysql_query($sql2);
             for($b = 1; $b < mysql_num_rows($result2) + 1; $b++)
             {
                 $speler_id = mysql_fetch_array($result2);
                 $speler = $competitie->speler_gegevens($speler_id["speler_id"]);
                 echo "<TR><TD>".$b.".<TD>".$speler["naam"]."<TD><a href=\"teams.php?actie=verwijderen&speler=".$speler_id["speler_id"]."&team=".$team["id"]."\">Verwijderen</a>";
             }
             
             echo "</TABLE>";