$matchedTraining_query = "SELECT * FROM $trainingtable";
$matchedTraining_result = mysql_query($matchedTraining_query) or die('Invalid query: ' . mysql_error());
$i = 0;

while ($matchedTraining_column = mysql_fetch_assoc($matchedTraining_result)) {
	$i++;
	$teamID = $matchedTraining_column['TeamID'];
	$trainDate = $matchedTraining_column['Training_Date'];
	$trLev = $matchedTraining_column['Trainer_Level'];
	$trSpec = $matchedTraining_column['Trainer_Specialty'];
	$trType = $matchedTraining_column['Training_Positions'];
	//print "Training for $teamID on $trainDate<br>\n";


	/* Find all player entries with minutes during this training entry */
	$trainedPlayers_query = "SELECT * FROM $trainingminstable WHERE TeamID=$teamID AND Training_Date like \"$trainDate%\" AND Training_Minutes=48";
	$trainedPlayers_result = mysql_query($trainedPlayers_query) or die('Invalid query: ' . mysql_error());
	while ($trainedPlayers_column = mysql_fetch_assoc($trainedPlayers_result)) {

		$playerID = $trainedPlayers_column['PlayerID'];
		$trainedMins = $trainedPlayers_column['Training_Minutes'];
		//print "Found player $playerID with $trainedMins minutes<br>\n";

		/* Get player info */
		$player_query = "Select * from $playerstable Where PlayerID=$playerID";
		$player_result = mysql_query($player_query) or die('Invalid query: ' . mysql_error());
		if (mysql_num_rows($player_result) > 0) {
			while ($player_column = mysql_fetch_assoc($player_result)) {
				foreach ($player_column as $key=>$value) {
					${$key} = $value;
				}
			}

			/* Check if player popped in the requested skill */
			$numpop_query = "SELECT COUNT(*) from $changelog Where PlayerID=$playerID AND Rating=\"$skill\" AND OldLevel>0 AND TrainDate like \"$trainDate%\"";
			$numpop_result = mysql_query($numpop_query) or die('Invalid query: ' . mysql_error());
			$numpops = mysql_result($numpop_result, 0);

			if ($format=="matlab") {
				print "data(end+1,:) = [";
				print "$trType $trainedMins $Age $Height $trLev $numpops";
				print "];<br>\n";
			} else {
				print "$trType,$trainedMins,$Age,$Height,$trLev,$numpops<br>";
			}


		} // if player in db

	} // while

} // while