Hjælp med mit cup system.

Her sætter den teams op til stage 1

<?php
session_start();
DB::Conn("open");
$cup_id = $_GET['cup_id'];
echo "Render list<br>";
$SQL = "SELECT team_teams_id FROM x_systems_team WHERE team_cup_id = '$cup_id'";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
$team1 = array();
$team2 = array();
$i = 0;
while ($Get = mysql_fetch_object($loadin)){
  $i++;
  if ( $i % 2 == 0 )
  {
    $team1[] = $Get->team_teams_id;
  }
  else
  {
    $team2[] = $Get->team_teams_id;
  }
}
shuffle( $team1 );
shuffle( $team2 );
$teams = array_combine($team1, $team2);
//foreach ( $teams as $t1 => $t2 )
for($x = 0; $x < count($team1); $x++)
{
//  echo "$t1 vs. $t2<br />";
    echo $team1[$x] . " vs. " . $team2[$x] . "<br>";
    mysql_query("INSERT INTO x_systems_result (
    result_team_id_a,
    result_team_id_b,
    result_cup_id
    ) VALUES (
    '".$team1[$x]."',
    '".$team2[$x]."',
    '".$cup_id."'
    )") or die (Java::Alert("MySQL Error: ".mysql_error()));
}
?>

Her godkender man resultatet og sender team til næste stage.

<div>

<table>
    <tr>
      <td style="border-bottom:1px black solid;" width="25px">Point</td>
    <td style="border-bottom:1px black solid;" width="150px" align="center">Team</td>
    <td style="border-bottom:1px black solid;" width="25px" align="center">VS.</td>
    <td style="border-bottom:1px black solid;" width="150px" align="center">Team</td>
    <td style="border-bottom:1px black solid;" width="25px">Point</td>
    <td style="border-bottom:1px black solid;">Valid?</td>
  </tr>
  <?
    $id = $Get->cup_id;
   
    $SQLa = "SELECT * FROM x_systems_result WHERE result_played = 'no'";
    $loadina = mysql_query($SQLa) or die("There is an Error in the database");
    while ($Geta = mysql_fetch_object($loadina))
        {
?>
<form action="pages/_resultlist.php" method="post">
<input type="hidden" name="do" value="valid">
<input type="hidden" name="stage" value="<?=$Geta->stage?>">
<input type="hidden" name="id" value="<?=$Geta->result_id?>">
    <tr>
      <td style="border-bottom:1px black dashed;" width="25px">
    <?
            $a = $Geta->result_team_id_a;
            $SQLb = "SELECT name FROM teams WHERE id = '$a'";
            $loadinb = mysql_query($SQLb) or die("There is an Error in the database");
            while ($Getb = mysql_fetch_object($loadinb))
                {
        ?>
        <input type="text" name="result_score_a" value="<?=$Geta->result_score_a?>" maxlength="2" style="width:20px;">
    </td>
    <td style="border-bottom:1px black dashed;" width="150px" align="center">
    <?
            echo $Getb->name;
            }
        ?>
    </td>
    <td style="border-bottom:1px black dashed;" width="25px" align="center">vs</td>
    <td style="border-bottom:1px black dashed;" width="150px" align="center">
    <?
            $b = $Geta->result_team_id_b;
            $SQLc = "SELECT name FROM teams WHERE id = '$b'";
            $loadinc = mysql_query($SQLc) or die("There is an Error in the database");
            while ($Getc = mysql_fetch_object($loadinc))
                {
                    echo $Getc->name;
        ?>
    </td>
    <td style="border-bottom:1px black dashed;" width="25px">
    <input type="text" name="result_score_b" value="<?=$Geta->result_score_b?>" maxlength="2" style="width:20px;">
        <? }?>
    </td>
    <td style="border-bottom:1px black dashed;">
    <input type="submit" name="submit" value="ok">
    </td>
  </tr>
  </form>
  <? }?>
</table>
</div>

her modtager den de teams som skal sendes vidre. men her skal den så også oprette nye team vs teams som ikke må gå igen alså teams i en stage må ikke genbruges og teams som ikke er kommet vidre til næste stage må ikke bruges i andre stages end den den er i.

<?
session_start();
include("../funktions/java.classes.php");
DB::Conn("open");
    if($_POST['do'] == "valid"){ //-- ````````````````````````````````````````````valid
                mysql_query("update x_systems_result set
                result_score_a = '".$_POST['result_score_a']."',
                result_score_b = '".$_POST['result_score_b']."',
                result_played = 'yes',
                stage = '".($_POST['stage'] + 1)."'
                WHERE result_id = '".$_POST['id']."'") or die (Java::Alert("MySQL Error: ".mysql_error()));
                Java::Alert("Team sendt vidre i cup");
                Java::GoToURL("../index.php?page=edit.validation");
            }elseif($_POST['do'] == ""){ //-- ````````````````````````````````````````MENU
                Java::Alert("To littel information!");
            }
?>

stiller et mindre spørsmål