Ankündigung

Einklappen
Keine Ankündigung bisher.

Datenbanktabelle erstellen - brauche Hilfe

Einklappen

Neue Werbung 2019

Einklappen
Dieses Thema ist geschlossen.
X
X
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

  • Datenbanktabelle erstellen - brauche Hilfe

    Hi Leute

    Ich habe in der Datenbank meiner Page Bärenstürmer - FC Wil 1900 Supporter ausversehen die Tabelle gelöscht, welche für den Spielplan zuständig ist. Da ich selber nichts davon verstehe brauche ich eure Hilfe. Der Inhalt der zuständigen PHP Datei habe ich mitgepostet. Könnt ihr mir sagen welche Werte meine neue Tabelle beinhalten muss?
    Feld, Typ, Attribute, Null, Standard, Extra - Was kommt in die Felder rein?
    Ich versteh leider sehr wenig davon, brauche aber die Tabelle dringend wieder um den neue Spieplan einzugeben. Vielen Dank schonmal für eure Hilfe.

    <?
    require("config.inc.php");
    include("header.php");
    ?>
    <table style="border: 0px; margin: auto; width: 100%;" cellpadding="4" cellspacing="1" class="tableinborder">
    <tr>
    <td style="text-align: left; width: 100%;" class="tablecat" colspan="6"><span class="normalfont"><b>Spielplan FC Wil 1900 - Vorbereitung Sommer 2007/2008</b></span></td>
    </tr>
    <tr>
    <td style="text-align: center; width: 5%;" class="tabletitle"><span class="smallfont"><b>Sp.</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Datum</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Uhrzeit</b></span></td>
    <td style="text-align: left; width: 45%;" class="tabletitle"><span class="smallfont"><b>Gegner</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>H/A</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>Erg.</b></span></td>
    </tr>
    <?
    $sql = "SELECT * FROM ".$gameplan." WHERE ligaspiel = '0' ORDER BY datum ASC";
    $result = mysql_query ($sql);
    if (mysql_num_rows ($result) >= 1)
    {
    $spieltag == "";
    while ($games = mysql_fetch_array($result))
    {
    $spieltag++;
    if($games[tore_plus] > $games[tore_minus])
    {
    $class = "aufsteiger";
    }
    elseif($games[tore_plus] < $games[tore_minus])
    {
    $class = "absteiger";
    }
    else
    {
    $class = "tablea";
    }
    $spieldatum = date("d.m.Y",$games[datum]);
    $spielzeit = date("H:i",$games[datum]);
    if($games[datum] >= time())
    {
    $games[tore_plus] = "";
    $games[tore_minus] = "";
    $class = "tablea";
    }
    ?>
    <tr>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieltag;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieldatum;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spielzeit;?></span></td>
    <td class="<?=$class;?>"><span class="smallfont"><?=$games[gegner];?></span></td>
    <td style="text-align: center;" class="<?=$class;?>"><span class="smallfont"><?=$games[heim_auswaerts];?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$games[tore_plus];?>-<?=$games[tore_minus];?></span></td>
    </tr>
    <?
    }
    }
    ?>
    <table style="border: 0px; margin: auto; width: 100%;" cellpadding="4" cellspacing="1" class="tableinborder">
    <tr>
    <td style="text-align: left; width: 100%;" class="tablecat" colspan="6"><span class="normalfont"><b>Spielplan FC Wil 1900 - Vorbereitung Winter 2007/2008</b></span></td>
    </tr>
    <tr>
    <td style="text-align: center; width: 5%;" class="tabletitle"><span class="smallfont"><b>Sp.</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Datum</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Uhrzeit</b></span></td>
    <td style="text-align: left; width: 45%;" class="tabletitle"><span class="smallfont"><b>Gegner</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>H/A</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>Erg.</b></span></td>
    </tr>
    <?
    $sql = "SELECT * FROM ".$gameplan." WHERE ligaspiel = '3' ORDER BY datum ASC";
    $result = mysql_query ($sql);
    if (mysql_num_rows ($result) >= 1)
    {
    $spieltag == "";
    while ($games = mysql_fetch_array($result))
    {
    $spieltag++;
    if($games[tore_plus] > $games[tore_minus])
    {
    $class = "aufsteiger";
    }
    elseif($games[tore_plus] < $games[tore_minus])
    {
    $class = "absteiger";
    }
    else
    {
    $class = "tablea";
    }
    $spieldatum = date("d.m.Y",$games[datum]);
    $spielzeit = date("H:i",$games[datum]);
    if($games[datum] >= time())
    {
    $games[tore_plus] = "";
    $games[tore_minus] = "";
    $class = "tablea";
    }
    ?>
    <tr>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieltag;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieldatum;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spielzeit;?></span></td>
    <td class="<?=$class;?>"><span class="smallfont"><?=$games[gegner];?></span></td>
    <td style="text-align: center;" class="<?=$class;?>"><span class="smallfont"><?=$games[heim_auswaerts];?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$games[tore_plus];?>-<?=$games[tore_minus];?></span></td>
    </tr>
    <?
    }
    }
    ?><br />

    </table>
    <br />

    <table style="border: 0px; margin: auto; width: 100%;" cellpadding="4" cellspacing="1" class="tableinborder">
    <tr>
    <td style="text-align: left; width: 100%;" class="tablecat" colspan="6"><span class="normalfont"><b>Spielplan FC Wil 1900 - Challenge League 2007/2008</b></span></td>
    </tr>
    <tr>
    <td style="text-align: center; width: 5%;" class="tabletitle"><span class="smallfont"><b>Sp.</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Datum</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Uhrzeit</b></span></td>
    <td style="text-align: left; width: 45%;" class="tabletitle"><span class="smallfont"><b>Gegner</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>H/A</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>Erg.</b></span></td>
    </tr>
    <?
    $sql = "SELECT * FROM ".$gameplan." WHERE ligaspiel = '1' ORDER BY datum ASC";
    $result = mysql_query ($sql);
    echo mysql_error();
    if (mysql_num_rows ($result) >= 1)
    {
    $spieltag == "";
    while ($games = mysql_fetch_array($result))
    {
    $spieltag++;
    if($games[tore_plus] > $games[tore_minus])
    {
    $class = "aufsteiger";
    }
    elseif($games[tore_plus] < $games[tore_minus])
    {
    $class = "absteiger";
    }
    else
    {
    $class = "tablea";
    }
    $spieldatum = date("d.m.Y",$games[datum]);
    $spielzeit = date("H:i",$games[datum]);
    if($games[datum] >= time())
    {
    $games[tore_plus] = "";
    $games[tore_minus] = "";
    $class = "tablea";
    }
    ?>
    <tr>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieltag;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieldatum;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spielzeit;?></span></td>
    <td class="<?=$class;?>"><span class="smallfont"><?=$games[gegner];?></span></td>
    <td style="text-align: center;" class="<?=$class;?>"><span class="smallfont"><?=$games[heim_auswaerts];?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$games[tore_plus];?>-<?=$games[tore_minus];?></span></td>
    </tr>
    <?
    }
    }
    ?>
    </table>
    <br />

    <table style="border: 0px; margin: auto; width: 100%;" cellpadding="4" cellspacing="1" class="tableinborder">
    <tr>
    <td style="text-align: left; width: 100%;" class="tablecat" colspan="6"><span class="normalfont"><b>Spielplan FC Wil 1900 - Swisscom Cup 2007/2008</b></span></td>
    </tr>
    <tr>
    <td style="text-align: center; width: 5%;" class="tabletitle"><span class="smallfont"><b>Sp.</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Datum</b></span></td>
    <td style="text-align: center; width: 15%;" class="tabletitle"><span class="smallfont"><b>Uhrzeit</b></span></td>
    <td style="text-align: left; width: 45%;" class="tabletitle"><span class="smallfont"><b>Gegner</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>H/A</b></span></td>
    <td style="text-align: center; width: 10%;" class="tabletitle"><span class="smallfont"><b>Erg.</b></span></td>
    </tr>
    <?
    $sql = "SELECT * FROM ".$gameplan." WHERE ligaspiel = '2' ORDER BY datum ASC";
    $result = mysql_query ($sql);
    echo mysql_error();
    if (mysql_num_rows ($result) >= 1)
    {
    $spieltag == "";
    while ($games = mysql_fetch_array($result))
    {
    $spieltag++;
    if($games[tore_plus] > $games[tore_minus])
    {
    $class = "aufsteiger";
    }
    elseif($games[tore_plus] < $games[tore_minus])
    {
    $class = "absteiger";
    }
    else
    {
    $class = "tablea";
    }
    $spieldatum = date("d.m.Y",$games[datum]);
    $spielzeit = date("H:i",$games[datum]);
    if($games[datum] >= time())
    {
    $games[tore_plus] = "";
    $games[tore_minus] = "";
    $class = "tablea";
    }
    ?>
    <tr>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieltag;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spieldatum;?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$spielzeit;?></span></td>
    <td class="<?=$class;?>"><span class="smallfont"><?=$games[gegner];?></span></td>
    <td style="text-align: center;" class="<?=$class;?>"><span class="smallfont"><?=$games[heim_auswaerts];?></span></td>
    <td style="text-align: right;" class="<?=$class;?>"><span class="smallfont"><?=$games[tore_plus];?>-<?=$games[tore_minus];?> <?=$games[zusatz];?></span></td>
    </tr>
    <?
    }
    }
    ?>
    </table>
    <?
    include("footer.php");
    ?>


  • #2
    Thread geschlossen, Crossposting.
    "Mein Name ist Lohse, ich kaufe hier ein."

    Kommentar

    Lädt...
    X