Leaderboard

<?php

$con = mysqli_connect('localhost', 'admin', 'admin', 'carnival_db');

if (mysqli_connect_errno())
 {
	echo "1: Connection failed";
	exit();
 }

 $mackillopquery = "SELECT SUM(score) FROM players WHERE house ='mackillop';";
 $namatjiraquery = "SELECT SUM(score) FROM players WHERE house ='namatjira';";
 $flynnquery = "SELECT SUM(score) FROM players WHERE house ='flynn';";
 $mitchellquery = "SELECT SUM(score) FROM players WHERE house ='mitchell';";
 $oodgerooquery = "SELECT SUM(score) FROM players WHERE house ='oodgeroo';";
 $parerquery = "SELECT SUM(score) FROM players WHERE house ='parer';";

 $firstquery = "SELECT username, house, MAX(score) FROM players WHERE score = (SELECT MAX(score) FROM players);";
 $secondquery = "SELECT username, house, MAX(score) FROM players WHERE score = (SELECT MAX(score) FROM players WHERE score <(SELECT MAX(score) FROM players));";
$thirdquery = "SELECT username, house, MAX(score) FROM players WHERE score = (SELECT MAX(score) FROM players WHERE score <(SELECT MAX(score) FROM players WHERE score <(SELECT MAX(score) FROM players)));";

$mackillopcheck = mysqli_query($con, $mackillopquery) or die("2: Name check query failed");
$namatjiracheck = mysqli_query($con, $namatjiraquery) or die("3: Name check query failed");
$flynncheck = mysqli_query($con, $flynnquery) or die("4: Name check query failed");
$mitchellcheck = mysqli_query($con, $mitchellquery) or die("5: Name check query failed");
$oodgeroocheck = mysqli_query($con, $oodgerooquery) or die("6: Name check query failed");
$parercheck = mysqli_query($con, $parerquery) or die("7: Name check query failed");

$firstcheck = mysqli_query($con, $firstquery) or die("8: Name check query failed");
$secondcheck = mysqli_query($con, $secondquery) or die("9: Name check query failed");
$thirdcheck = mysqli_query($con, $thirdquery) or die("10: Name check query failed");



$existingmackillop = mysqli_fetch_assoc($mackillopcheck);
$existingnamatjira = mysqli_fetch_assoc($namatjiracheck);
$existingflynn = mysqli_fetch_assoc($flynncheck);
$existingmitchell = mysqli_fetch_assoc($mitchellcheck);
$existingoodgeroo = mysqli_fetch_assoc($oodgeroocheck);
$existingparer = mysqli_fetch_assoc($parercheck);

$existingfirst = mysqli_fetch_assoc($firstcheck);
$existingsecond = mysqli_fetch_assoc($secondcheck);
$existingthird = mysqli_fetch_assoc($thirdcheck);

echo "0";
echo "\t";
echo $existingmackillop["SUM(score)"];
echo "\t";
echo $existingnamatjira["SUM(score)"];
echo "\t";
echo $existingflynn["SUM(score)"];
echo "\t";
echo $existingoodgeroo["SUM(score)"];
echo "\t";
echo $existingmitchell["SUM(score)"];
echo "\t";
echo $existingparer["SUM(score)"];
echo "\t";

echo $existingfirst["username"];
echo "\t";
echo $existingfirst["MAX(score)"];
echo "\t";
echo $existingfirst["house"];
echo "\t";

echo $existingsecond["username"];
echo "\t";
echo $existingsecond["MAX(score)"];
echo "\t";
echo $existingsecond["house"];
echo "\t";

echo $existingthird["username"];
echo "\t";
echo $existingthird["MAX(score)"];
echo "\t";
echo $existingthird["house"];
echo "\t";

?>