0 order by EVENTS2016 desc"; $db_erg = mysql_query( $sql); while ($dsatz = mysql_fetch_array( $db_erg)) { echo " ". $dsatz["DRIVER"] . " ". $dsatz["EVENTS"] . " ". $dsatz["ZIEL"] . " ". $dsatz["DNF"] . " ". $dsatz["PROZENT"] . " ". $dsatz["BEST"] . " ". $dsatz["OVT"] . " ". $dsatz["LL"] . " ". $dsatz["FIRST_EVENT"] . " ". $dsatz["LAST_EVENT"] . " "; } break; } elseif($_POST["JAHR"] == "2015") { $sql = "SELECT DRIVER, Events2015 as EVENTS, ZIEL2015 as ZIEL, DNF2015 as DNF, PROZENT2015 as PROZENT, BEST2015 as BEST, SIEG2015 as SIEG, TOP102015 as TOP10, SRVSIEG2015 as SRVSIEG, OVT2015 as OVT, LL2015 as LL, FIRST_EVENT, LAST_EVENT from jos_gtlr_rank_events where Events2015 > 0 order by EVENTS desc"; $db_erg = mysql_query( $sql); while ($dsatz = mysql_fetch_array( $db_erg)) { echo " ". $dsatz["DRIVER"] . " ". $dsatz["EVENTS"] . " ". $dsatz["ZIEL"] . " ". $dsatz["DNF"] . " ". $dsatz["PROZENT"] . " ". $dsatz["BEST"] . " ". $dsatz["OVT"] . " ". $dsatz["LL"] . " ". $dsatz["FIRST_EVENT"] . " ". $dsatz["LAST_EVENT"] . " "; } break; } elseif($_POST["JAHR"] == "2014") { $sql = "SELECT DRIVER, Events2014 as EVENTS, ZIEL2014 as ZIEL, DNF2014 as DNF, PROZENT2014 as PROZENT, BEST2014 as BEST, SIEG2014 as SIEG, TOP102014 as TOP10, SRVSIEG2014 as SRVSIEG, OVT2014 as OVT, LL2014 as LL, FIRST_EVENT, LAST_EVENT from jos_gtlr_rank_events where Events2014 > 0 order by EVENTS desc"; $db_erg = mysql_query( $sql); while ($dsatz = mysql_fetch_array( $db_erg)) { echo " ". $dsatz["DRIVER"] . " ". $dsatz["EVENTS"] . " ". $dsatz["ZIEL"] . " ". $dsatz["DNF"] . " ". $dsatz["PROZENT"] . " ". $dsatz["BEST"] . " ". $dsatz["OVT"] . " ". $dsatz["LL"] . " ". $dsatz["FIRST_EVENT"] . " ". $dsatz["LAST_EVENT"] . " "; } break; } else { $sql = "SELECT DRIVER, skill, skill_events_total, skill_events, Skill_events_percent, skill_ziel, skill_dnf, skill_percent, skill_laps_total, skill_laps, skill_laps_percent from res_driver order by skill desc"; $db_erg = mysql_query( $sql); while ($dsatz = mysql_fetch_array( $db_erg)) { echo " ". $dsatz["DRIVER"] . " ". $dsatz["skill"] . " ". $dsatz["skill_events_total"] . " ". $dsatz["skill_events"] . " ". $dsatz["Skill_events_percent"] . " ". $dsatz["skill_ziel"] . " ". $dsatz["skill_dnf"] . " ". $dsatz["skill_percent"] . " ". $dsatz["skill_laps_total"] . " ". $dsatz["skill_laps"] . " ". $dsatz["skill_laps_percent"] . " "; } break; } echo ""; echo ""; //xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx default: include "db_connect.inc.php"; include "Drivers_aus_header_one.inc.php"; include "countersingle.php"; include "counter.php"; $sql = "SELECT * FROM res_results WHERE DRIVER = '" . $_POST["drivers"] . "' AND datum LIKE '" . $_POST["JAHR"] . "%' ORDER BY datum desc"; $db_erg = mysql_query( $sql); while ($dsatz = mysql_fetch_array( $db_erg)) { echo " ". $dsatz["event"] . " ". $dsatz["pos"] ." ". $dsatz["racetime"] ." ". $dsatz["laps"] ." ". $dsatz["skin"] ." ". $dsatz["server"] ." ". $dsatz["serverpos"] ." ". $dsatz["fastestlap"] ." ". $dsatz["fastestqualy"] ." ". $dsatz["OVT"] ." ". $dsatz["LL"] ." "; } } ?>