Tweet
PHP-Code:
<?
$verbindung = mysql_connect($MySQL_HOST,$MySQL_USER,$MySQL_PASSWORT) or die (mysql_error());
mysql_select_db($MySQL_DB);
$result = mysql_query("SELECT * FROM srl_session ORDER BY 'ID' asc limit 0,1") or die(mysql_error());
while($row = mysql_fetch_array($result)) {
$Strecke = $row['Strecke'];
$Bilder = $row['Bilder'];
$typ = $row['Typ'];
echo "<font color=#FFFFFF size=3 face=verdana><b><div style=\"width:100%; filter:Shadow(color=#000000, direction=135)\">$Strecke - <img src='images/strecken-bilder/flagge_$Bilder.gif' border=1><p>$typ</div>";
}
echo "<p> <table width=99% border=0 bordercolordark=#cccccc bordercolorlight=#FFFFFFF cellpadding=1 cellspacing=0><tr><td class=tc><center>Platz</td><td class=tc><center>Name</td><td class=tc><center>Team</td><td class=tc><center>Zeit</td><td class=tc><center>Split-1</td>
<td class=tc><center>Split-2</td><td class=tc><center>GAP</td><td class=tc><center>Status</td></tr>";
$platz = '0';
$verbindung = mysql_connect($MySQL_HOST,$MySQL_USER,$MySQL_PASSWORT) or die (mysql_error());
mysql_select_db($MySQL_DB);
$result2 = mysql_query("SELECT * FROM srl_aktuelle_session ORDER BY 'Zeit' asc limit 0,1") or die(mysql_error());
while($row = mysql_fetch_array($result2)) {
$zeit1 = $row['Zeit'];
}
$verbindung = mysql_connect($MySQL_HOST,$MySQL_USER,$MySQL_PASSWORT) or die (mysql_error());
mysql_select_db($MySQL_DB);
$result2 = mysql_query("SELECT * FROM srl_aktuelle_session ORDER BY 'Zeit' asc") or die(mysql_error());
while($row = mysql_fetch_array($result2)) {
$name = $row['Name'];
$team = $row['Team'];
$split1 = $row['Split1'];
$split2 = $row['Split2'];
$zeit2 = $row['Zeit'];
$gap = '$zeit2' - '$zeit1';
$status = $row['Status'];
if ($status == '') {
$status = 'N/A';
} else {
$status = $row['Status'];
}
$platz ++;
$kommentar = $row['Kommentar'];
$date = $row['Date'];
echo "<tr><td><div style=\"width:100%; filter:Shadow(color=#000000, direction=135)\"><font color=#FFFFFF face=verdana size=2><center>$platz</center></div></td><td><font color=#FFFFFF face=verdana size='-7'><center>$name</font></td><td><font color=#FFFFFF><font color=#FFFFFF face=verdana size=1><center>$team</font></td><td><font color=#FFFFFF><font color=#FFFFFF face=verdana size=1><center>$zeit2</font></td><td><font color=#FFFFFF><font color=#FFFFFF face=verdana size=1><center>$split1</font></td>
<td><font color=#FFFFFF face=verdana size=1><center>$split2</font></td><td><font color=#FFFFFF face=verdana size=1><center>$gap</font></td><td><font color=#FFFFFF face=verdana size=1><center>$status</font></td></tr>";
}
echo "</table>";
include ("includes/copyright.php");
?>
Kommentar