<?php
session_start();
error_reporting(0);
include('includes/config.php');
?>
<?php
$servername = "localhost";
$username = "root";
$paassword="";
$dbname="trfs";
$conn = new mysqli($servername,$username,$paassword,$dbname);
if ($conn->connect_error) {
die("Say". $conn->connect_error);
}
$points = 0;
$sql = "SELECT
Team, Sum(P) AS P,Sum(W) AS W,Sum(D) AS D,Sum(L) AS L,
SUM(F) as F,SUM(A) AS A,SUM(GD) AS GD,SUM(Pts) AS Pts
FROM(
SELECT
home ,
1 P,
IF(for > against,1,0) W,
IF(for = against,1,0) D,
IF(for < against,1,0) L,
for F,
against A,
for-against GD,
CASE WHEN for > against THEN 3 WHEN for = against THEN 1 ELSE 0 END PTS
FROM results
UNION ALL
SELECT
away,
1 P,
IF(for < against,1,0)W,
IF(for = against,1,0)D,
IF(for > against,1,0)L,
against A,
for F,
against-for GD,
CASE WHEN for < against THEN 3 WHEN for = against THEN 1 ELSE 0 END
FROM results
) as tot
GROUP BY Team
ORDER BY SUM(Pts) DESC";
$results = mysqli_query($conn, $sql);
$resultsCheck = mysqli_num_rows($results);
if ($resultsCheck > 0) {
while($row = $result->fetch_assoc()) {
}
} else {
echo "0 results";
}
$conn->close();
?>