[insert_php] try {
include ‘../vars.php’;
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query = “SELECT Team, sum(homewin) as Home_Win, sum(awaywin) as Away_Win, sum(homedraw+awaydraw) as Draw, sum(homerainedoff + awayrainedoff) as Rain_Off, sum(homeDefeats + awayDefeats) AS Lost, sum(points) as Points FROM

(

SELECT hometeam as team, sum(draw) as homedraw, 0 as awaydraw, sum(hometeam_win) as homewin, 0 as awaywin, sum(r_off) as homerainedoff, 0 as awayrainedoff, sum(home_team_points) as points, sum(awayteam_win) as homeDefeats, 0 as awayDefeats
FROM division1_results_2018
GROUP BY hometeam

UNION

SELECT awayteam as team, 0 as homedraw, sum(draw) as awaydraw, 0 as homewin, sum(awayteam_win) as awaywin, 0 as homerainedoff, sum(r_off) as awayrainedoff, sum(away_team_points) as points , 0 as homeDefeats, sum(hometeam_win) as awayDefeats
FROM division1_results_2018
GROUP BY awayteam
) DIVISION

GROUP BY Team
ORDER BY Points DESC”;
//first pass just gets the column names
print “

“;
$result = $con->query($query);
//return only the first row (we only need field names)
$row = $result->fetch(PDO::FETCH_ASSOC);
print ”

“;
foreach ($row as $field => $value){
print ”

“;
} // end foreach
print ”

“;
//second query gets the data
$data = $con->query($query);
$data->setFetchMode(PDO::FETCH_ASSOC);
foreach($data as $row){
print ”

“;
foreach ($row as $name=>$value){
print ”

“;
} // end field loop
print ”

“;
} // end record loop
print “

$field
$value

“;

} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
} // end try
[/insert_php]