1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
|
<html>
<head>
<Coded by Test>
<title>Test</title>
<link rel="stylesheet" href="../style.css" type="text/css">
</head>
<?php
// Verbindung zur Datenbank
include ('db.php');
$ID = "$_GET[ID]";
$Ergebnis = mysql_query( "SELECT * FROM Turniere where ID='$ID'" );
$Name = $row['Vorschau'];
if (@mysql_num_rows($Ergebnis) == 0) {
echo "Dieses Pferd existiert nicht!";
}
else {
$Data = mysql_fetch_array( $Ergebnis );
echo "<body background='../Style/HG.jpg'>
<img border='0' src='Test/Pferde/Bilder/$Data[Vorschau]/Lang.jpg' width='414' height='114'><br><br>";
}
?>
<center><table class'table3' width='414' height='64'>
<tr>
<td class='table3' colspan='4' width='677' height='1' align='center'><b><font face='Verdana' size='1'>Übersicht</font></b></td>
</tr>
<tr>
<td class='table1' width='120' height='22' align='center'><b><font face='Verdana' size='1'>Platzierung</font></b></td>
<td class='table1' width='120' height='22' align='center'><b><font face='Verdana' size='1'>Schleife/Pokal</font></b></td>
<td class='table1' width='120' height='22' align='center'><b><font face='Verdana' size='1'>Disziplin
& LK</font></b></td>
<td class='table1' width='120' height='22' align='center'><b><font face='Verdana' size='1'>Reiter</font></b></td>
</tr>
<?php
$sql = mysql_query("SELECT * FROM Turniere WHERE Pferd = '$Name' ORDER BY Schleife");
while($row=mysql_fetch_assoc($sql)){
echo "<tr>
<td class='table2' width='120' height='22' align='center'><font size='1' face='Verdana'>$Data[Platzierung]</font></td>
<td class='table2' width='120' height='22' align='center'><font size='1' face='Verdana'><img border='0' src='Test/Style/Turniergrafiken/$Data[Schleife].png' width='50' height='50'></td>
<td class='table2' width='120' height='22' align='center'><font size='1' face='Verdana'>$Data[Disziplin]</font></td>
<td class='table2' width='120' height='22' align='center'><font size='1' face='Verdana'>$Data[Reiter]</font></td>
</tr>
</table></center>";
}
if (mysql_errno()) die ("MySQL-Error: " . mysql_error());
mysql_close();
?>
</center>
</body>
</html> |
