phpBB.de

Code: Alles auswählen

$sql = "SELECT COUNT(tipp_points) as anzahl FROM " . FORMEL_TIPPS_TABLE . "
	WHERE tipp_race = $race_id
	GROUP BY tipp_points
	ORDER BY tipp_points DESC LIMIT 3";
if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query formel_tipps', '', __LINE__, __FILE__, $sql);
}

Code: Alles auswählen

while($row = mysql_fetch_object($result))
{
	$anz_place = $row->anzahl;

	echo $anz_place;
	echo "<br>";
}

Code: Alles auswählen

		$i = 1;
		while($row = mysql_fetch_object($result))
		{
			$var_name = "anz_place_" . $i;
			$$var_name = $row->anzahl;
			$i++;
		}

Code: Alles auswählen

// Place 1
if ($anz_place_1 == '1')
{
	$bet_race_place_1 = ($bet_race_place_1 / $anz_place_1);
}
elseif ($anz_place_1 == '2')
{
	$bet_race_place_1 = (($bet_race_place_1 + $bet_race_place_2) / $anz_place_1);
}
elseif ($anz_place_1 > '2')
{
	$bet_race_place_1 = ($bet_race_sum / $anz_place_1);
}

// Place 2
if ($anz_place_1 == '1' && $anz_place_2 == '1')
{
	$bet_race_place_2 = ($bet_race_place_2 * $anz_place_2);
}
elseif ($anz_place_1 == '1' && $anz_place_2 >= '2')
{
	$bet_race_place_2 = (($bet_race_place_2 + $bet_race_place_3) / $anz_place_2);
}

// Place 3
if ($anz_place_1 == '1' && $anz_place_2 == '1' && $anz_place_3 >= '1')
{
	$bet_race_place_3 = (((($bet_race_sum/'100') * $race_place_3)) / $anz_place_3);
}
elseif ($anz_place_1 == '2' && $anz_place_2 >= '1')
{
	$bet_race_place_3 = ($bet_race_place_3 / $anz_place_2);
}