";
echo "| " . getUserInfo($username) . " | ";
$sql="SELECT * FROM $table_matches m LEFT JOIN $table_tipps gmt ON m.matchnr=gmt.matchnr AND gmt.user='$username' WHERE m.matchtype='Gruppenspiel' ";
$sqlResult=mysql_query($sql);
while($array=mysql_fetch_array($sqlResult)){
$matchnr=$array["matchnr"];
$tippGoalsTeam1=$array["goalsX"];
$tippGoalsTeam2=$array["goalsY"];
$evaluationDone=$array["evaluationDone"];
if($evaluationDone === "T"){
// get points
$points = $array["score"];
if($points == NULL){ // should not happen when evaluation is already done, but use default then
echo "$tippGoalsTeam1 : $tippGoalsTeam2 | ";
} else if($points == 0){ // print white
echo "$tippGoalsTeam1 : $tippGoalsTeam2 | ";
} else if($points == 2){ // print light blue
echo "$tippGoalsTeam1 : $tippGoalsTeam2 | ";
} else if($points == 4){ // print light green
echo "$tippGoalsTeam1 : $tippGoalsTeam2 | ";
}
} else {
//echo "$tippGoalsTeam1 | : | $tippGoalsTeam2 | ";
echo "$tippGoalsTeam1 : $tippGoalsTeam2 | ";
}
}
echo "
";
}
?>