I have a html file with php in it that is suppose to be querying a MYSQL database for information about the top 25 players with their kills deaths etc. However the page keeps loading blank and I cannot work out what is wrong. The database does have plenty of entries into it. The server hosting this file also does have PHP installed. Could someone please show me where the issue is or tell me what could be causing this issue? Cheers Code:
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title></title>
</head>
<body>
<?php
require_once( "connect.php" );
$select_top_25 = "
SELECT `stats_players`.`name`,
`stats_total_pvp_kills`.`times`,
`stats_total_deaths`.`times`
FROM `stats_players`
INNER JOIN `stats_total_pvp_kills`
BY `stats_players`.`player_id` = `stats_total_pvp_kills`.`player_id`
INNER JOIN `stats_total_deaths`
BY `stats_players`.`player_id` = `stats_total_deaths`.`player_id`
ORDER BY `stats_total_pvp_kills`.`times` ASC LIMIT 25";
$result = mysqli_query($link, $select_top_25) or die (mysqli_error($link));
$counter = 0;
while($row = mysqli_fetch_row($result))
{
$counter = $counter + 1;
print '#'.$counter;
print 'Name: '.$row[0];
print 'Kills: '.$row[1];
print 'Deaths: '.$row[2];
}
?>
</body>
</html>