Q:

How to display using PHP language, highest values from column inside HTML

    <div class="col-sm-5 col-md-12 col-lg-6">
      <div class="panel panel-inverse">
        <div class="panel-heading">
          <h4 class="panel-title">TOP 5 BUNNY KILLERS</h4>
        </div>
        <div class="panel-body">
          <ul class="media-list user-list">
           <?php echo $output ?>
            <?php echo $output ?>
             <?php echo $output ?>
              <?php echo $output ?>
               <?php echo $output ?>
          </ul>
        </div>
      </div>
    </div>

$sql = "SELECT Username, BunnyKilled FROM users order by BunnyKilled DESC LIMIT 5;";
$con=mysqli_connect("yes","yes","yes","yes");
$results =  array();
$result = mysqli_query($con,$sql);
$results = mysqli_fetch_all($result, MYSQLI_ASSOC);

$output = '';

foreach ($results as $result) {
$output = '  <li class="media"> <div class="media-left"> <a href="#">  <img class="media-object img-circle" src="../images/photos/user9.png" alt=""> </a> </div> <div class="media-body"> <h4 class="media-heading"><a href="">'. $result['Username'] . '</a></h4> <span>' . $result['BunnyKilled'] . '</span> bunny killed</div> </li>' ;
    }

I'm also using 
if(isset($_SESSION['username']))

for showing personal information of the bunny killer, but the top 5 bunny killers I want to show every killer ordered by their number of bunny killed. after what it didn't work, I put var dump and this is what I got
array(5) {
  [0]=>
  array(2) {
    ["Username"]=>
    string(19) "Abdulhamit_Yildirim"
    ["BunnyKilled"]=>
    string(2) "15"
  }
  [1]=>
  array(2) {
    ["Username"]=>
    string(4) "Ampo"
    ["BunnyKilled"]=>
    string(1) "5"
  }
  [2]=>
  array(2) {
    ["Username"]=>
    string(15) "Timothy_Bronson"
    ["BunnyKilled"]=>
    string(1) "5"
  }
  [3]=>
  array(2) {
    ["Username"]=>
    string(6) "Rvmses"
    ["BunnyKilled"]=>
    string(1) "4"
  }
  [4]=>
  array(2) {
    ["Username"]=>
    string(3) "Esy"
    ["BunnyKilled"]=>
    string(1) "3"
  }
}

just updated var_dump results which i've put it after fetch

A:

Your MySQL query should look something like:
SELECT * FROM looneytunes order by BunnyKilled DESC LIMIT 5;
The top 5 are by the order by, limit 5.
Your php should look something like:
   <?php 
            $sql = "SELECT Username, BunnyKilled FROM users order by BunnyKilled DESC LIMIT 5;";

            $results =  array();
            $result = mysqli_query($con,$sql);

            $results = mysqli_fetch_all($result, MYSQLI_ASSOC);

        $output = '';

            foreach ($results as $row) {

        $output .= '  <li class="media"> <div class="media-left"> <a href="#">  <img class="media-object img-circle" src="../images/photos/user9.png" alt=""> </a> </div> <div class="media-body"> <h4 class="media-heading"><a href="">'. $row['Username'] . '</a></h4> <span>' . $row['BunnyKilled'] . '</span> bunnies killed</div> </li>' ;
            }

        echo $output;

?>

