Tidslinje

= ’$start_date’ AND
M.MatchPlaceID LIKE ’$placeid’ AND
M.MatchGoals IS NOT NULL AND
M.MatchGoalsOpponent IS NOT NULL
ORDER BY M.MatchDateTime
”, $connection)
or die(mysql_error());

$k=0;
while($data_m = mysql_fetch_array($get_matches))
{

if($data_m[’goals’] > $data_m[’goals_o’])
{
$wins = $wins + 1;
$streak++;
$streak2++;
$t = $k + 1;
$track = 1;
$track2 = 1;
}

if($data_m[’goals’] == $data_m[’goals_o’])
{
$draws = $draws + 1;
$streak=0;
$track = 0;
$track2 = 1;
$streak2++;
}

if($data_m[’goals’] < $data_m['goals_o']) { $loses = $loses + 1; $streak=0; $streak2=0; $track = 0; $track2 = 0; } $goals_for = $goals_for + $data_m['goals']; $goals_against = $goals_against + $data_m['goals_o']; if($k > 0)
{
if($track == 1)
{
if($streak >= $record)
{
$record = $streak;
}
}

if($track2 == 1)
{
if($streak2 >= $record2)
{
$record2 = $streak2;
}
}
}

$k = $k +1;
}

$all = $wins + $loses + $draws;

if($all == 0)
{
$win_pros = round(0, 2);
$draw_pros = round(0, 2);
$lose_pros = round(0, 2);
}
else
{
$win_pros = round(100*($wins/$all), 2);
$draw_pros = round(100*($draws/$all), 2);
$lose_pros = round(100*($loses/$all), 2);
}

mysql_free_result($get_matches);

?>

% % % = ’$start_date’ AND
M.MatchPlaceID LIKE ’$placeid’
LEFT OUTER JOIN tplss_goals G ON G.GoalPlayerID = S.SeasonPlayerID AND G.GoalMatchID = M.MatchID AND G.GoalOwn = ’0’
WHERE P.PlayerID != ”
GROUP BY id
ORDER BY goals DESC, name
”, $connection)
or die(mysql_error());

$i=0;
$check=92892892892;

while($data = mysql_fetch_array($query))
{
if($i==0)
{
echo”$data[name]”;
$best_goal_amount = $data[’goals’];
}

if($i > 0)
{
if($data[’goals’] == $check)
{
echo”, $data[name]”;
}
else
{
break;
}
}

$check = $data[’goals’];
$i++;
}

echo” ($best_goal_amount)”;

mysql_free_result($query);

?> = ’$start_date’ AND
M.MatchPlaceID LIKE ’$placeid’
LEFT OUTER JOIN tplss_yellowcards Y ON Y.YellowCardPlayerID = S.SeasonPlayerID AND Y.YellowCardMatchID = M.MatchID
WHERE P.PlayerID != ”
GROUP BY id
ORDER BY yellows DESC, name
”, $connection)
or die(mysql_error());

$i=0;
$check=92892892892;

while($data = mysql_fetch_array($query))
{
if($i==0)
{
echo”$data[name]”;
$most_yellows = $data[’yellows’];
}

if($i > 0)
{
if($data[’yellows’] == $check)
{
echo”, $data[name]”;
}
else
{
break;
}
}

$check = $data[’yellows’];
$i++;
}

echo” ($most_yellows)”;

mysql_free_result($query);

?> = ’$start_date’ AND
M.MatchPlaceID LIKE ’$placeid’
LEFT OUTER JOIN tplss_appearances A ON A.AppearancePlayerID = S.SeasonPlayerID AND A.AppearanceMatchID = M.MatchID
WHERE P.PlayerID != ”
GROUP BY id
ORDER BY apps DESC, name
”, $connection)
or die(mysql_error());

$i=0;
$check=92892892892;

while($data = mysql_fetch_array($query))
{
if($i==0)
{
echo”$data[name]”;
$most_apps = $data[’apps’];
}

if($i > 0)
{
if($data[’apps’] == $check)
{
echo”, $data[name]”;
}
else
{
break;
}
}

$check = $data[’apps’];
$i++;
}

echo” ($most_apps)”;

mysql_free_result($query);

?>