>

filter by:

-- all countries-- ".$countryArray[$i]."\r\n"; } ?>

--all schools-- ".$schoolArray[$i]."\r\n"; } ?>

--all sports-- ".$sportArray[$i]."\r\n"; } ?>

link array $schoolLinkFile = fopen('/www/cstv/html/database_inc/oasschools_olympics.txt','r') or die("Can't open $php_errormsg"); $schoolLinkArray = array(); while(! feof($schoolLinkFile)) { $l = rtrim(fgets($schoolLinkFile,2048)); list($school,$link) = explode(" ",$l); $school = htmlspecialchars($school); $schoolLinkArray[$school] = $link; } # switch bgcolor on alternating rows $bgColor1 = "#CCCCCC"; $bgColor2 = "#EEEEEE"; $bgColor = $bgColor1; # grab users $query = "SELECT country, sport, athlete, school, year, event, result FROM olympics2004 "; $query .= $filter." "; $query .= "ORDER by $orderby"; # echo $query."
"; $qresult = @ mysql_query ($query, $connection) or showerror(); $loopCount = 0; if (mysql_query ($query, $connection)) { while ($row = mysql_fetch_array($qresult)) { if ($loopCount == 0) { ?> (click column name to sort)

".$school.""; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; # echo "\n"; echo "\n"; if ($bgColor==$bgColor1) $bgColor=$bgColor2; else $bgColor=$bgColor1; $loopCount++; } } if ($loopCount > 0) { ?>

Country	Sport	Athlete	School	Year	Event
".$row['country']."	".$row['sport']."	".$row['athlete']."	".$school."	".$row['year']."	".$row['event']."	".$row['result']."

Olympians are based on CollegeSports.com research as of .
To add or correct an olympic list, e-mail us at fans1@cstv.com.
There are no results for the filtering detailed above.