Mit folgendem Code möchte ich Datenbankinhalte in einem Artikel anzeigen. Leider klappt das niht. Im Browser als reine php-Seite geht es.
Hier mal der Code:
Code: Alles auswählen
<?
//HEADER
//////////////////////////////////
include("admin/config.inc.php");
include("admin/functions.php");
connect_to_db();
//////////////////////////////////
////////////////////////////////////////////////// SPIELER LADEN
$spieler_sql = "SELECT * FROM Spieler ORDER BY Name asc";
$spieler_entries = mysql_query($spieler_sql);
$spieler_rows = mysql_num_rows($spieler_entries);
?>
<style type="text/css">
<!--
.Stil7 {
font-size: 12px;
font-weight: bold;
font-family: Verdana, Arial, Helvetica, sans-serif;
}
.Stil9 {font-size: 12px}
.Stil10 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
a:link {
color: #333333;
}
a:visited {
color: #333333;
}
a:hover {
color: #666666;
}
a:active {
color: #666666;
}
.table-border {
border: 1px solid #173D62;
}
.Stil11 {
font-size: 16;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
}
.Stil12 {color: #FFFFFF}
-->
</style>
</head>
<body>
<?
$data_sql = "SELECT * FROM Spieler WHERE ID_Spieler_PK ='".$id."'";
$data_entries = mysql_query($data_sql);
//$data_rows = mysql_num_rows($data_entries);
while ($data = mysql_fetch_array($data_entries)) {
$id = $data[ID_Spieler_PK];
$name = $data[Name];
$vorname = $data[Vorname];
$strasse = $data[Strasse];
$plz = $data[PLZ];
$ort = $data[Wohnort];
$geburtstag = $data[Geburtstag];
$liga = $data[ID_Liga_PK];
$mannschaft = $data[Mannschaft];
$spielklasse = $data[ID_Spielklasse_PK];
$telpriv = $data[telpriv];
$teldienst = $data[teldienst];
$faxpriv = $data[faxpriv];
$faxdienst = $data[faxdienst];
$handy = $data[handy];
}
?>
<div align="center">
<table width="600" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td align="left" valign="top" class="Stil10">Bitte wählen Sie einen Spieler aus der Liste:<br><br> </td>
<td width="298" align="left" valign="top" class="Stil10"> </td>
</tr>
<tr valign="top">
<td align="left" valign="top" class="Stil10"><form name="form" method="post" action="">
<select name="$FORM_[id]" size="1" id="$FORM_[id]">
<?
while ($spielerdata = mysql_fetch_array($spieler_entries)) {
echo "<option value=".$spielerdata[ID_Spieler_PK].">".$spielerdata[Name]."</option>\n";
}
?>
</select>
<input type="submit" name="Submit" value="Senden">
</form> </td>
<td align="left" valign="top" class="Stil10"> </td>
</tr>
<tr valign="top">
<td align="left" valign="top" class="Stil10"> </td>
<td align="left" valign="top" class="Stil10"> </td>
</tr>
<tr valign="top">
<td align="left" valign="top" class="Stil10"> Name: <br><br></td>
<td align="left" valign="top" class="Stil10">
<? echo $name;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Vorname:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $vorname;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Strasse:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $strasse;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> PLZ:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $plz;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Wohnort:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $ort;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Geburtstag:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $geburtstag;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Liga:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $liga;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Mannschaft:<br><br></td>
<td align="left" valign="top" class="Stil10"><? echo $mannschaft;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Spielklasse:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $spielklasse;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Telefon priv.:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $telpriv;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span> Telefon dienstl.:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $teldienst;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span><span class="Stil10 Stil9"> </span> Fax priv.:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $faxpriv;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span><span class="Stil10 Stil9"> </span> Fax dienstl.:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $faxdienst;?></td>
</tr>
<tr>
<td align="left" valign="top" class="Stil10"><span class="Stil10 Stil9"> </span><span class="Stil10 Stil9"> </span> Handy:<br>
<br></td>
<td align="left" valign="top" class="Stil10"><? echo $handy;?></td>
</tr>
</table>