// Database connection variables $dbServer = "localhost"; $dbDatabase = "everythingredwing"; $dbUser = "root"; $dbPass = "pcsinc33"; $sConn = mysql_connect($dbServer, $dbUser, $dbPass) or die("Couldn't connect to database server"); $dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase"); $race_code=$_GET['race_code']; $race_year=$_GET['race_year']; //we dont want people changing the query string if ($race_year>2050 OR $race_year<1950){ $race_year='ALL YEARS'; } //echo $race_code; if ($race_code=="GOTR"){ $race_name="Just Winging It(Girls on the Run) 5k - ".$race_year; } if ($race_code=="7kKD"){ $race_name="Kiwanis Dawnbreakers 7k - ".$race_year; } if ($race_code=="15kKD"){ $race_name="Kiwanis Dawnbreakers 15k - ".$race_year; } if ($race_code=="6kKD"){ $race_name="Kiwanis Dawnbreakers 6k - ".$race_year; } if ($race_code=="10kRCD"){ $race_name="River City Days 10k - ".$race_year; } if ($race_code=="5kRCD"){ $race_name="River City Days 5k - ".$race_year; } //echo $race_name $dbQuery = "SELECT * "; $dbQuery .= "FROM Running_Races "; if ($race_year=="ALL YEARS") { $dbQuery .= "WHERE Race='".$race_code."' "; $dbQuery .= "ORDER BY Time"; }else{ $dbQuery .= "WHERE Race='".$race_code."' AND Year LIKE '".$race_year."' "; $dbQuery .= "ORDER BY Overall_Place"; } //echo '.............'.$dbQuery. '..............'; $result = mysql_query($dbQuery) or die("Couldn't get file list"); ?>
4th of July Race at Bay Point |
|||
2003 Dawnbreakers Kiwanis July 4th -6k |
2003 Dawnbreakers Kiwanis July 4th -15k |
||
|
Overall |
Catagory |
Name |
if ($race_year="ALL YEARS") { ?> Race Year |
}else{ ?>
Race #
} ?>
City |
Age |
Gender |
Time |
Mile Pace |