rendered paste body<?php mysql_select_db($database_szvvweb, $szvvweb);$query_teams = "SELECT id_team, idver_team, klasse_team, naam_team, shirt1_team, shirt2_team, shirt3_team, broek1_team, broek2_team, broek3_team, kous1_team, kous2_team, kous3_team, id_klasse, nr_klasse, naam_klasse FROM teams, klasse WHERE idver_team = ".$row_vers2['id_ver']." AND nr_klasse = klasse_team ORDER BY naam_team ASC";$teams = mysql_query($query_teams, $szvvweb) or die(mysql_error());$totalRows_teams = mysql_num_rows($teams);while ($row_teams = mysql_fetch_assoc($teams)) { $kleuren = getColorName($row_teams['shirt1_team']);}function getColorName($color) { $kleurenSQL = " SELECT kleuren.naam_kleur FROM kleuren WHERE kleuren.code_kleur = '$color'"; $kleuren_Res = mysql_query($kleurenSQL); $kleuren_Row = mysql_fetch_assoc($kleuren_Res); return $kleuren_Row['naam_kleur'];}?>