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.
Zitat:
<?
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");
?>
|
14.06.2008, 09:54
Datenbanktabelle erstellen - brauche Hilfe 
Ähnliche Themen 
