druzyna A team 1 : <? showTeamPick("A", 1); ?>

<?

$db_user = "edb_12852";
$db_name = "edb_12852";
$db_host = "37.187.173.135";
$db_password = "5euir3aVR8";

$conn =  @new mysqli($db_host, $db_user, $db_password, $db_name);



function showTeamPick($group, $team)
{
	$sql = "SELECT * FROM `users`  WHERE `group".$group."pick` >0"; //pobieramy osoby w grupie które zagłosowali ogólnie 20
	$query = $conn->query($sql);
	$ile = $query->num_rows; // mamy :)

	$sql1 = "SELECT * FROM `users`  WHERE `group".$group."pick` =$team";  // 1
	$query1 = $conn->query($sql1);
	$ile1 = $query1->num_rows; // mamy :)
	$result = ($ile/$ile1) * 100;

	echo $result;
}

?>